Results 1 to 4 of 4
  1. #1
    Join Date
    Dec 2003

    Unanswered: MySQL database replication between sersvers

    I have a website being hosted. It has a MySQL db. I am running a webserver at home with a copy of the website for testing etc. IS there an easy way to cpy the db from on to the other? Droopping the data+structure works, except for one table which is to big to reload (get time out problems).

    Is there a way to reload via the commandline instead of PHP for instance?

    On the webhosting site I only have a PHPMyAdmin type interface. I can't shell to access the db

  2. #2
    Join Date
    Jun 2003
    Phoenix, AZ
    drop table TABLE;
    load table TABLE from master;

  3. #3
    Join Date
    Jan 2004

    Re: MySQL database replication between sersvers


    if you don't have commandline access then there is no other way as using php.

    you can use the set_time_limit(XX) command in php to set the time limit of a php script to unlimited(X=0), or if you are in a loop you can use the set_time_limit inside the loop. in every call the time limit counter is reseted.

    check out php documentation

  4. #4
    Join Date
    Jan 2004
    Actually it's pretty easy. Use one of the newer version of PHPMyAdmin and just make sure you use the database export option and choose compression of your choice. I just exported a 15 gig database to make sure that it worked fine and it worked for me.

    Then on your local box uncompress the dump and drop it in on your hosted server and you are all done.


Posting Permissions

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