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.

No comments:

Post a Comment

Featured Post

Install gammu on centos 7

To install Gammu on CentOS 7, follow these steps: 1. Update the system: Bash sudo yum update 2. Install dependencies: Bash sudo yum install...