Problems using phpMyAdmin dump on local MySQL administrator/ Query Browser
Ok I give in, I cannot get data obtained from phpMyAdmin into my local database at all! I've tried:
- Saving export as .SQL file and restoring using MySQL Administrator but I get a message that the file was not created using MySQL Administrator.
- I've tried doing a table with data dump and using that SQL query in MySQL Query Browser but it only inserts a few rows instead of all 1050.
What am I doing wrong?? I can't seem to find much info on this particular problem. I want to manipulate data locally instead of over a slow network connection as my queries are getting pretty complex...
When you use phpMyAdmin to export your data, you must use again phpMyAdmin to import data into local server.
If you don't have local phpMyAdmin you must manual correct and execute your SQL script.
Bookmarks