Re: Data from local PC MySQL (or MSAccess) to remote UNIX MySQL

look at the mysqldump docs on mysql.com look at the mysqlimport docs on mysql.com Basically, you want to dump your data to a text file: on the commandline: mysqldump -u username -p -v database > dbbackup.txt and reload it like this on the commandline: mysql -u username -p database < dbbackup.txt See www.mysql.com for more information. -Jason Garber IonZoft.com At 04:13 PM 10/10/2001 -0500, Tome wrote:

Hi:) I am new to OpenSource and programming. How can I get data from my local PC MySQL database (or MSAccess) to the remote ISP MySQL database?There must be a simple method for this :-) I have been an NT administrator, and made the jump to OpenSource. Some of the simple things to do in SQLServer seem complicated using MySQL. I set up phpAdmin 2.2.0 on my remote ISP's UNIX box: I am able to browse the phpAdmin 2.2.0 Welcome page, and have protected the folder with .htaccess. I remotely created a table in the database which mimics the table I have on my local Windows2000 PC. Locally, the table and data had originally been created in MSAccess and was exported to my local MySQL database. That was a menu-driven one step procedure. Now, I am trying to figure out how to get the data from my local PC MySQL database (or MSAccess) to the remote ISP MySQL database. There must be a simple method for this. I am new to OpenSource, so I need step-by-step instructions. Should I give up? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net