How do I clone a database?

d3vcho

• January 05, 2020 12:15

Basically title. I have a 300MB database that I need to copy into another website for testing. If I do it using phpMyAdmin, I'll always get timeouts. Is there any other way of doing this?

• 

  keat63

  • January 06, 2020 13:39

  I suffered something similar and for the life of me can't recall exactly what I did or find the forum post. I seem to recall that I may have increased the amount of memory available to MYSQL alternatively, this might help

  0
• 

  ffeingol

  • January 06, 2020 15:40

  If you have shell access it's quite easy: [CODE=bash]mysqldump -u USER-ID -p DATABASE-NAME > DUMP-FILE-NAME
  USER-ID is your MySQL user-id DATABASE-NAME is the database name DUMP-FILE-NAME is the path/filename of the dump file you want to create To load the new database (assuming you have already created it) [CODE=bash]mysql -u USER-ID -p DATABASE-NAME < DUMP-FILE-NAME
  If you don't have shell access your may need to ask your provider to do this for you.

  0
• 

  d3vcho

  • January 06, 2020 17:01

  That made it! Thank you very much for the help :)

  0
• 

  d3vcho

  • January 06, 2020 17:03

  That made it! @ffeingol Thank you very much for the help :)

  
  

  0
• 

  cPanelLauren

  • January 06, 2020 21:41

  I'm glad to see you were able to get this completed! Thanks for the advice @ffeingol

  0

Please sign in to leave a comment.