# 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.
No comments:
Post a Comment