leungeric.com

Digg del.icio.us Technorati StumbleUpon Twitter

Import / Restore Large MySQL Data File

MySQL | Tutorials & Resources

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... 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

  • Digg
  • del.icio.us
  • Technorati
  • StumbleUpon
  • Reddit
  • TwitThis
  • Sphinn
  • BlinkList
  • Furl
  • Mixx
  • NewsVine
  • Slashdot
  • Ma.gnolia
  • Facebook
  • Google
  • E-mail this story to a friend!

No Comments, Comment or Ping

Reply to “Import / Restore Large MySQL Data File”

Sponsors