Sunday, December 30, 2007

import large mysql dumps via command line

Are you tired by maximum execution time errors, php time out errors or mysql import size error?

Author: Naqi Khan

Do you got BIG Size database dumps and try to import quickly?

Don't worry there is a simple way :)
I am assuming you are logged in as root on your server

# database=db-name-here <>

Suppose your db is in your public_html folder

# database=db-name-here < /home/accountname/public_html/dbdump.sql

And hit enter YOU ARE DONE MY FRIEND :)

Thanks

No comments: