RE: Re[2]: [PHP] mysql

When you are importing the information into your database in Linux, use the mysql command, not the mysqldump command. HTH Sam Masiello System Analyst Chek.Com (716) 853-1362 x289 smasiello@chekinc.com -----Original Message----- From: Ali Ahmad H [mailto:ali@francha.co.id] Sent: Thursday, November 02, 2000 10:40 AM To: Sam Masiello Cc: PHP General Subject: Re[2]: [PHP] mysql Sam, i have already used a mysqldump, here's what i've done: - on NT (MS-DOS) i wrote: mysqldump -u user -p mypassword mydatabase > myfile.txt - then i put myfile.txt to the linux server via ftp's soft - on the linux i made the new database (ex: mydata) - then i wrote: mysqldump -u user -p mypassword mydata < myfile.txt the process was successful with no error, but the table was not created in my data's database. is my command wrong ? or maybe because the difference of the mysqldump version ? (on NT using # MySQL dump 8.6 and on LInux using # MySQL dump 7.1) Regards, -ali- Thursday, November 02, 2000, 9:17:24 PM, Sam, menulis : SM> Instead of actually trying to move the physical database files, consider SM> doing a mysqldump of all of the tables on your NT machine, moving those SM> files to your Linux server (via your favorite file transfer method) and load SM> them from the command line. SM> There might be a better way to do this, but not being familiar with the file SM> naming and such with MySQL on an NT machine, this method should work without SM> any problem. SM> HTH SM> Sam Masiello SM> System Analyst SM> Chek.Com SM> (716) 853-1362 x289 SM> smasiello@chekinc.com