I'm using MySQL as database with Windows server. I'm having 5 GB of data in database. Now I need to change my server and the question is that how can I transfer complete 5 GB data to one mysql database to another mysql database in Fastest way? What is the Easiest and Fastest method to do that? Any method / query / tool anyway?
5
-
2Faster than what? Have you tried anything at all?– JNKCommented Mar 19, 2013 at 12:08
-
@JNK Sorry I corrected my question. It is Fastest and I couldn't find any way to do that directly– DhavalCommented Mar 19, 2013 at 12:33
-
1You have currently tagged both sql-server and mysql. When you say that you want to transfer "[from] one database to another database" do you mean "from MySQL to Microsoft SQL Server"? Please clarify your question.– Gord ThompsonCommented Mar 19, 2013 at 12:37
-
@GordThompson Edit Done– DhavalCommented Mar 19, 2013 at 12:41
-
3Dhaval you might want to be specific even more. Like, do you have any down time window to perform this activity? Or you wanted to do without letting your customers to know about the migration. If yes let me know their sleeping hours :)– MannojCommented Mar 19, 2013 at 12:45
Add a comment
|
1 Answer
You are going to want to have a backup of your database anyway, so just do a full backup, copy it from the old server to the new one, and then restore it there.
-
Thanks for your answer Gord. Are you talking about simply import and export the database? if yes then there will be some limit of uploading and excecuting the query and if now then please let me know from where I can directly backup the database and restore it as I'm new to use server– DhavalCommented Mar 19, 2013 at 12:59
-
Not export/import per se, but standard MySQL backup and restore processes, as outlined in the MySQL documentation here. Commented Mar 19, 2013 at 13:21