Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
2  
Faster than what? Have you tried anything at all? –  JNK Mar 19 '13 at 12:08
    
@JNK Sorry I corrected my question. It is Fastest and I couldn't find any way to do that directly –  Dhaval Mar 19 '13 at 12:33
1  
You 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 Thompson Mar 19 '13 at 12:37
    
@GordThompson Edit Done –  Dhaval Mar 19 '13 at 12:41
3  
Dhaval 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 :) –  Mannoj Mar 19 '13 at 12:45

1 Answer 1

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.

share|improve this answer
    
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 –  Dhaval Mar 19 '13 at 12:59
    
Not export/import per se, but standard MySQL backup and restore processes, as outlined in the MySQL documentation here. –  Gord Thompson Mar 19 '13 at 13:21

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.