SitePoint Sponsor

User Tag List

Results 1 to 7 of 7
  1. #1
    SitePoint Enthusiast
    Join Date
    May 2006
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    export from phpmyadmin, import using MySQL administrator

    Hi, title says it all....almost

    I need to move a mysql database. I have access to the database I want to move using phpMyAdmin, I have access to the database I want to move it to using MySQL Administrator.

    Whatever settings I export from using phpmyadmin, MySql Administrator doesn't like to import ?

    Can anyone advise on settings ? or an alternative tool to use for importing to the new database ?

    Thanks in advance.

  2. #2
    dooby dooby doo silver trophybronze trophy
    spikeZ's Avatar
    Join Date
    Aug 2004
    Location
    Manchester UK
    Posts
    13,807
    Mentioned
    158 Post(s)
    Tagged
    3 Thread(s)
    what errors are you getting from the MySQL administrator?
    Mike Swiffin - Community Team Advisor
    Only a woman can read between the lines of a one word answer.....

  3. #3
    SitePoint Enthusiast
    Join Date
    May 2006
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks for your help. I export form phpmyadmin to a sql file.

    When I try and 'restore' in MySQL administrator I get the message:

    'The dump file was not created with MySQL Administrator. Currently only such dumps can also be restored.'

    I'm trying other import settings, but same message. Do you know of an alternative tool I could use ?

  4. #4
    SitePoint Evangelist
    Join Date
    Aug 2005
    Posts
    453
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Open the sql file with a text editor, Cut and paste each statement into MySQL adminitstrator one at a time.
    You should create the database, create users, create tables, and restore your data.
    Computers and Fire ...
    In the hands of the inexperienced or uneducated,
    the results can be disastrous.
    While the professional can tame, master even conquer.

  5. #5
    SitePoint Enthusiast
    Join Date
    May 2006
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Thanks,
    I cannot find how to run sql in MySQL adminitstrator ?

  6. #6
    SitePoint Evangelist
    Join Date
    Aug 2005
    Posts
    453
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Go to Tools => MySQL Query Browser
    Computers and Fire ...
    In the hands of the inexperienced or uneducated,
    the results can be disastrous.
    While the professional can tame, master even conquer.

  7. #7
    SitePoint Enthusiast
    Join Date
    May 2006
    Posts
    61
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi, Thanks, getting to know my way around mysql administrator a bit now. However this is a large database and line by line will take me days.

    Does anyone know of an alternative method to import a phpmyadmin sql export ? ( I guess I should look at installing phpmyadmin for the target database ?, could have done that by now !)

    Thanks again.


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
  •