Solved

export tables from mysql 5.5 database

Posted on 2011-02-18
2
885 Views
Last Modified: 2012-05-11
I keep trying to run a data dump on one of the databases I have created in mysql 5.5.8 with the workbench gui program 5.2.31. I have already pointed the mysqldump.exe to the 5.5 version. Copied it a different posistion on the hard drive to see if that helped it then pointed workbench to that version. Nothing is working. Please help.
0
Comment
Question by:blitzone
2 Comments
 
LVL 4

Expert Comment

by:LAMASE
ID: 34930688
- have you a dump file (file.sql)?
- did you executed the query contained in the file in the new database? Any errors?

note that your dump file is probably a big query... it can take lot of time executing remotely.
0
 
LVL 83

Accepted Solution

by:
Dave Baldwin earned 500 total points
ID: 34930842
'mysqldump' may be version sensitive.  Type 'mysqldump -V' to see which MySQL Distribution it is for.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword This is an old article.  Instead of using the MySQL extension that was used in the original code examples, please choose one of the currently supported database extensions instead.  More information is available here: MySQLi / PDO (http://…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

832 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question