Professional Web Applications Themes

Moving PHP MySQL Guestbook from one host to another - MySQL

I have a MySQL Guestbook in PHP on a webhosting server and might be moving to a new hosting provider. How would I go about "getting" my database and moving it to the new provider as the guestbook entries are important to me and I don't want to lose what I already have. Any tips/suggestions to help a MySQL/PHP newbie. Thanks...

  1. #1

    Default Moving PHP MySQL Guestbook from one host to another

    I have a MySQL Guestbook in PHP on a webhosting server and might be
    moving to a new hosting provider.
    How would I go about "getting" my database and moving it to the new
    provider as the guestbook entries are important to me and I don't want
    to lose what I already have.
    Any tips/suggestions to help a MySQL/PHP newbie.
    Thanks


    Guest

  2. #2

    Default Re: Moving PHP MySQL Guestbook from one host to another

    "" <newskidsnews.au.org> wrote in message
    news:sIOdnfFa8OWQ3GHenZ2dnUVZ8qOdnZ2dpipex.net...
    > How would I go about "getting" my database and moving it to the new
    > provider
    MySQL software provides a backup tool called 'mysqldump', which produces a
    backup file you can download with FTP, then upload to your new host and
    restore it using the 'mysql' CLI. However, the question is what method is
    available to you since you have your database on a web hosting service.
    Often such services don't give you access to the command-line tools that
    come with MySQL.

    It is often the case that hosting providers give you access to a web-based
    MySQL administration tool, usually phpmyadmin. This web-based tool also has
    a backup facility, but I'm not sure it saves a dump that is compatible with
    the mysqldump files. You may have to use phpmyadmin on the destination host
    as well, to import the database.

    The best answer depends on what tools are provided by each of your two
    hosting services.

    Regards,
    Bill K.


    Bill Karwin Guest

  3. #3

    Default Re: Moving PHP MySQL Guestbook from one host to another

    > I have a MySQL Guestbook in PHP on a webhosting server and might be
    > moving to a new hosting provider.
    > How would I go about "getting" my database and moving it to the new
    > provider as the guestbook entries are important to me and I don't want
    > to lose what I already have.
    > Any tips/suggestions to help a MySQL/PHP newbie.
    If phpMyAdmin is installed on both host,
    it should be easy to export and import db:
    [url]http://www.phpmyadmin.net/[/url]

    Or if you have telnet access you could use mySQL
    export and import functions.

    If none of the above, it is not so hard to write a
    routine in php to do the export and import of db.

    arnulf [url]http://s-a.no/[/url]
    Arnulf Sortland Guest

Similar Threads

  1. Replies: 3
    Last Post: March 29th, 02:45 AM
  2. Unknown MySQL Server Host 'localhost '
    By jason mazzotta in forum PHP Development
    Replies: 1
    Last Post: December 7th, 04:15 AM
  3. Replies: 3
    Last Post: November 25th, 09:37 AM
  4. Free PHP3 and Mysql host
    By L'alsacien Strasbourg in forum PHP Development
    Replies: 2
    Last Post: November 3rd, 08:49 PM
  5. Hep req. with PHP and MySQL - simple guestbook
    By Phlarmf in forum PHP Development
    Replies: 3
    Last Post: September 21st, 08:17 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139