Export and import big data mysql with mysqldump

To export big data on mysql use this command:
# mysqldump -u [username] -p [databasename] | gzip > [filename.sql.gz]

To import big data on mysql
First you must extract compress file  [filename.sql.gz] to [filename.sql]

#mysql -u  [username] -p
mysql> use [databasename];
mysql> source path/to/[filename.sql];
 If your data is too big, the import process can be used long time, wait until finished. If not you must try from Import process.

Thx.

Comments

Popular posts from this blog

Fail Running Glassfish server on port 8080