To export

大佬教程收集整理的这篇文章主要介绍了To export，大佬教程大佬觉得挺不错的，现在分享给大家，也给大家做个参考。

1. 分隔

 >>split -l 5 data_out.sql test

2.重命名

>>for j in test*; do mv -v -- "$j" "$j.sql";done

To export

If it's an entire DB,then:

@H_697_14@mysqLdump sql

If it's all DBs,then:

@H_697_14@mysqLdump  all_db_BACkup.sql

If it's specific tables within a DB,then:

@H_697_14@mysqLdump sql

You can even go as far as auto-compressing the output using gzip (if your DB is very big):

@H_697_14@mysqLdump sql

If you want to do this remotely and you have the access to the server in question,then the following would work (presuming the MysqL server is on port 3306):

@H_697_14@mysqLdump sql

To import

Type the following command to import sql data file:

@H_697_14@mysqL sql

In this example,import 'data.sql' filE into 'blog' database using Sathish as username:

@H_697_14@mysqL sql

If you have a deDicated database server,replace localhost hostname with with actual server name or IP address as follows:

@H_697_14@mysqL sql

OR use hostname such as Mysql.cyberciti.biz

@H_697_14@mysqL @H_697_14@mysqLsql

If you do not kNow the database name or database name is included in sql dump you can try out something as follows:

@H_697_14@mysqL sql

Refer: 

If you want a GUI tool then you could probably use 

参考文献：

http://stackoverflow.com/questions/11407349/MysqL-how-to-export-and-import-an-sql-file-from-command-line

大佬总结

以上是大佬教程为你收集整理的To export全部内容，希望文章能够帮你解决To export所遇到的程序开发问题。

如果觉得大佬教程网站内容还不错，欢迎将大佬教程推荐给程序员好友。

本图文内容来源于网友网络收集整理提供，作为学习参考使用，版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ：384754419，请注明来意。