Re[4]: [PHP] mysql

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