Jump to content


copy mysql database to DIFFERENT name

  • Please log in to reply
1 reply to this topic

#1 mojito

  • Members
  • PipPipPip
  • Advanced Member
  • 74 posts

Posted 24 April 2006 - 03:26 PM

Its easy to dump a database using phpmyadmin, however I would like to know how to dump this file to a new database name. I tried modifying the sql at the top where it creates the database. This gave an error.

I have putty and would like to know how i can use it locally to do this stuff from a command line.

Any help with any of the above is greatly appreciated.


#2 fenway

  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 24 April 2006 - 05:28 PM

It should be as easy as adding "CREATE DATABASE <yourDBname>" followed by "USE <yourDBname>" at the top.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users