#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2000
    Location
    san francisco, ca ,usa
    Posts
    1
    Rep Power
    0
    well i might be jumping the gun a little. so say i want to first backup a mysql database from my company server to my laptop. I have working versions of both mysql and php up and running. I've tried mysqldump and i dont think i have the syntax right would someone please show me how to backup all the databases of a computer then restoring it on another.
    any feedback would greatly be appreciated
  2. #2
  3. Contributing User
    Devshed Novice (500 - 999 posts)

    Join Date
    Feb 2000
    Location
    Perth West Australia
    Posts
    757
    Rep Power
    15
    Do you have phpMyAdmin installed? if so there is an option to 'view dump(schema) of database xxx' select 'structure and data' and hit go - this gives you page you can cut and paste , paste it into the 'run SQL queries' textbox in phpMyAdmin on your machine and a complete copy will be made.

    if you do not have it - www.phpwizards.net is where you can find it !

    ------------------
    Simon Wheeler
    FirePages -DHTML/PHP/MySQL

IMN logo majestic logo threadwatch logo seochat tools logo