Tutorial : Restore MySQL Backup File Using cmd Prompt

How to restore huge mysql backup file ?
  • Open Command Prompt
  • c:\>cd program files (x86)  
  • c:\>cd mysql  
  • c:\>cd mysql server 5.1 ( depends on your MySQL folder name )
  • c:\>cd bin
  • c:\>mysql -u <username> -p 
  • <insert mysql password>
  • mysql>use <databasename>
  • mysql> source D:\backup.sql (depends on location where you store the backup files)
  • Wait until it's done.

Hope this will help you 

xoxo!

0 comments:

Post a Comment

Sila tinggalkan komen dengan penuh kasih sayang.
Terima Kasih. (^_^)