neo777ph Posted August 2, 2007 Share Posted August 2, 2007 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? Quote Link to comment https://forums.phpfreaks.com/topic/62964-copy-and-paste-on-mysql-to-mysql-database/ Share on other sites More sharing options...
hitman6003 Posted August 2, 2007 Share Posted August 2, 2007 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. Quote Link to comment https://forums.phpfreaks.com/topic/62964-copy-and-paste-on-mysql-to-mysql-database/#findComment-313525 Share on other sites More sharing options...
teng84 Posted August 2, 2007 Share Posted August 2, 2007 yeah works perfect if the same version but if not theres a big chance to get the error Quote Link to comment https://forums.phpfreaks.com/topic/62964-copy-and-paste-on-mysql-to-mysql-database/#findComment-313532 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.