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...