Re[4]: [PHP] mysql From: Ali Ahmad H (ali <email protected>)
Date: 11/02/00

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 <email protected>

SM> -----Original Message-----
SM> From: Ali Ahmad H [mailto:ali <email protected>]
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 <email protected> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-general-unsubscribe <email protected>
For additional commands, e-mail: php-general-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>