To export big data on mysql use this command:
To import big data on mysql
First you must extract compress file [filename.sql.gz] to [filename.sql]
Thx.
# 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]
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.#mysql -u [username] -p
mysql>use
[databasename];
mysql>source path/to/
[filename.sql];
Thx.
Comments
Post a Comment