Showing posts with label mysql. Show all posts
Showing posts with label mysql. Show all posts

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.

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...