Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.
Moderator: General Moderators
gastonlm
Forum Commoner
Posts: 26 Joined: Tue May 07, 2002 10:19 am
Location: Buenos Aires, Argentina
Contact:
Post
by gastonlm » Mon May 13, 2002 4:21 pm
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
fatal
Forum Contributor
Posts: 118 Joined: Sat Apr 20, 2002 10:47 am
Location: East Coast
Post
by fatal » Mon May 13, 2002 4:36 pm
you can use this: 'mysql -e "source /patch-to-backup/backup-file.sql" database' to use the database you dumped on a different server.
gastonlm
Forum Commoner
Posts: 26 Joined: Tue May 07, 2002 10:19 am
Location: Buenos Aires, Argentina
Contact:
Post
by gastonlm » Mon May 13, 2002 4:39 pm
How do I do that?
fatal
Forum Contributor
Posts: 118 Joined: Sat Apr 20, 2002 10:47 am
Location: East Coast
Post
by fatal » Mon May 13, 2002 4:40 pm
through shell access, i believe
gastonlm
Forum Commoner
Posts: 26 Joined: Tue May 07, 2002 10:19 am
Location: Buenos Aires, Argentina
Contact:
Post
by gastonlm » Tue May 14, 2002 9:12 am
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?
fatal
Forum Contributor
Posts: 118 Joined: Sat Apr 20, 2002 10:47 am
Location: East Coast
Post
by fatal » Tue May 14, 2002 10:16 am
gastonlm
Forum Commoner
Posts: 26 Joined: Tue May 07, 2002 10:19 am
Location: Buenos Aires, Argentina
Contact:
Post
by gastonlm » Tue May 14, 2002 10:31 am
It worked, thank you very much!!
fatal
Forum Contributor
Posts: 118 Joined: Sat Apr 20, 2002 10:47 am
Location: East Coast
Post
by fatal » Tue May 14, 2002 12:04 pm
No problem dude