Solved

export tables from mysql 5.5 database

Posted on 2011-02-18
2
884 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL Update Query 23 93
Bubble user-defined Sql RAISERROR(...) to c# exception 14 147
Problem with Simple PHP/mySQL Query 3 52
Create a Select Query and Populate a Table 3 45
This guide whil teach how to setup live replication (database mirroring) on 2 servers for backup or other purposes. In our example situation we have this network schema (see atachment). We need to replicate EVERY executed SQL query on server 1 to…
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://…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

863 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now