Jump to content

Copy and Paste on MySQL to MySQL Database


neo777ph

Recommended Posts

Would there be any issues if i literary Copy and Paste a mysql db from one server to another mysql db server?

When i say "copy and paste" is just like tranferring one word doc from one pc to another pc.

 

I tried the copy and paste already and the new server had recognize the DB i had pasted.

I just want to confirm if there would be issues doing it so.. Or should i use Mysql.com Migration toolkit?

So long as it's the same version of MySQL, and you copy ALL of the files, it may work. 

 

I've never tried, as whenever I have a need to do something like that, I take the opportunity to upgrade MySQL to the newest version and use mysqldump to export the data, then import it with mysqladmin.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.