Jul 30, 2008
Import / Restore Large MySQL Data File
(3.67 out of 5)
Loading ...A simple 3-steps procedure to import/restore large MySQL data file via command line.
A 200mb data file should take less than a minute to complete.
1. Telnet or SSH to server
2. Login to MySQL
mysql -u user -ppassword
3. At MySQL prompt
use your_database_name
source your_sql_data_file.sql
One Comment, Comment or Ping
certifications
Wow….
That’s so simple, really I haven’t any idea of it but I believe that it really enhance my knowledge. Thanks for sharing this stuff.
Jul 9th, 2009
Reply to “Import / Restore Large MySQL Data File”