August 23rd, 2000, 04:57 PM
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
August 26th, 2000, 03:40 AM
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 !