Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 PHPMyadmin Dump to SQL Enterprise

Author  Topic 

paulferree
Starting Member

8 Posts

Posted - 2008-07-17 : 21:15:13
I have a Mysql dump from phpmyadmin. How can I either:

A. Import it into SQL Enterprie.

B. Import it into MySql Administrator (the regular import tool didn't work and I can't figure out how to run it from the command line). This is the error I'm getting: "The selected file was generated by mysqldump and cannot be restored by this application."

If I do B I can sync MySql and Enterprise up as I've done that before.


Any ideas?

Thanks!
Paul

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-18 : 02:58:06
would you not be better advised to post your question on a MySQL forum?

Em
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-19 : 13:33:39
A. if the file is in text or csv format, you can load it into sql table with bcp or bulk insert.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-19 : 14:57:01
When you say SQL Enterprise, do you mean Enterprise Manager, SQL Server Enterprise Edition, or something other thing?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

elancaster
A very urgent SQL Yakette

1208 Posts

Posted - 2008-07-19 : 16:15:19
i think sql enterprise is something to do with MySQL still

Em
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-19 : 17:20:23
Agreed, but I wanted to double check.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -