SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot ninjayong's Avatar
    Join Date
    May 2006
    Location
    Holland
    Posts
    135
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

  2. #2
    SitePoint Member
    Join Date
    Mar 2008
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •