Page 1 of 1

IMPORT DATABASE

Posted: Mon May 13, 2002 4:21 pm
by gastonlm
People, I have dumped a database and I want to import it. I did it with the phpmyadmin. Could you anybody help me to do this? I'm new in phpdevelopment

Posted: Mon May 13, 2002 4:36 pm
by fatal
you can use this: 'mysql -e "source /patch-to-backup/backup-file.sql" database' to use the database you dumped on a different server.

Posted: Mon May 13, 2002 4:39 pm
by gastonlm
How do I do that?

Posted: Mon May 13, 2002 4:40 pm
by fatal
through shell access, i believe

Posted: Tue May 14, 2002 9:12 am
by gastonlm
I'm trying to import it but I recive the following error:
ERROR 1064 at line 1: You have an error in your sql sintax near 'file.sql' at line 1
My be it doesn't find the file. Have you even seen that error?

Posted: Tue May 14, 2002 10:16 am
by fatal

Posted: Tue May 14, 2002 10:31 am
by gastonlm
It worked, thank you very much!!

Posted: Tue May 14, 2002 12:04 pm
by fatal
No problem dude