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

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