SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Zealot
    Join Date
    Oct 2000
    Posts
    146
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hello,
    I am moving off my temp free server to a paid one. I am using phpMyAdmin with both and I was wondering what was the easiest way to move the SQL database to the new host.
    thanks.

  2. #2
    Irritability Defined
    Join Date
    Jul 2000
    Location
    80,000 feet below the surface
    Posts
    1,442
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I'll have an article on WebmasterBase.com out soon about moving and backing up your databases fairly shortly.

    In the meantime, the ideal situation is : if you have Telnet/SSH access, access your server then do a 'mysqldump' e.g. :

    mysqldump --opt –full your_database_name > thisismybackupfile.sql

    then once you get on to the new host, use phpMyAdmin to create a new DB and upload the 'text file' (your .sql file) to re-populate the database.

    If you don't have Telnet/SSH access and want to use phpMyAdmin, then follow these instructions from PHPWizard.net : http://www.phpwizard.net/phorum/read...&i=1157&t=1157
    My 2 Cents (or is that 2.2 Cents including GST?)


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
  •