RE: [PHP] Export/Import data from local PC MySQL database to remote ISP MySQL database.

You can use mysqldump to create a SQL file that can be run to recreate the state of your db on the remote machine. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: Tome [mailto:tome@aol.com] > Sent: Wednesday, October 10, 2001 5:08 PM > To: php-general@lists.php.net > Subject: [PHP] Export/Import data from local PC MySQL database to remote > ISP MySQL database. > > > 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 General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >