Forums » General Discussion

Thread: Transfer MySQL -> MySQL

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 1 - Pages: 1 - Last Post: Jan 17, 2012 9:10 AM by: Mauritz Threads: [ Previous | Next ]
Talon

Posts: 1
Registered: 1/17/12
Transfer MySQL -> MySQL
Posted: Jan 17, 2012 2:51 AM
 
  Click to reply to this thread Reply

I really think this needs to be looked at more carefully.  Yes you can export to csv then import again.  But I think it would be so much easier if you could select all the tables, fight click and choose "send to"->"mysql database"

In which case you select the target and click go.

A problem I ran into while trying to do this operation is that I exported db1 to sql.  But when I tried to import those files again there is not facility to "import" sql files.  Which is strange...  Surely if I ca export to those files I should be able to import from the same files again?



Mauritz

Posts: 313
Registered: 8/23/07
Re: Transfer MySQL -> MySQL
Posted: Jan 17, 2012 9:10 AM   in response to: Talon
 
  Click to reply to this thread Reply

If you have a SQL file just open it in the editor and run it.


Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums