Jump to content


Photo

Transfering MySql Databases


  • Please log in to reply
1 reply to this topic

#1 Desertwar

Desertwar
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 22 February 2006 - 02:06 AM

Does anyone know how to transfer the contents from one MySql database to another on the same server? I use Cpanel with Cron.

#2 fenway

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

Posted 22 February 2006 - 03:17 AM

Assuming you have access to the box itself, just copy over the MYI/MYD files after creating the new database. Otherwise, mysqldump out and use the command-line to read the whole thing in again.
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