[PHP] Importing into GoDaddy's MySQL system - Tilted Forum Project Discussion Community

wombatman · 07-18-2006, 09:01 PM

I have a database with one table that I've done up on a local version of MySQL. I would like to move this database onto a hosting account with GoDaddy. I cannot, however, find a way to simply upload/import the database, as opposed to having to redo all the scripting.

There is an option to import a text file, but they give no specifications as to what the text file needs to contain to import correctly (and when I tried a text file of just the column names and the column data, it failed miserably).

Any help with this would be greatly appreciated.

captobvious · 07-18-2006, 09:41 PM

It's most likely looking for a text file with a sequence of SQL commands. That's what a backup of a MySQL database is anyway. Fortunately, there's a utility that comes with MySQL that generates this file for you called mysqldump. Here's the command to use it:

mysqldump –-user username –-password=password databasename > data.sql

You should replace the values in italics with your info.

That command will dump everything from the databasename you specify into the "data.sql" file. This is the text file you should try importing to your account on GoDaddy.

For a more detailed explanation, check out this article. Hope that helps.

wombatman · 07-18-2006, 10:01 PM

Well, unfortunately, mysqldump does not seem to want to work. I tried it using your (and the article you linked's) syntax, but when I try to execute the command, it gives me a syntax error.

I checked to make sure mysqldump was in the bin folder, and it is. I also tried "mysqldump --opt database01". That also gave a syntax error. I'm sure I'm missing some blatantly simple thing, but I can't figure it out for the life of me. The fact that it's 2AM probably doesn't help.

Any further ideas as to why I'm getting this error?

captobvious · 07-18-2006, 10:38 PM

What is the syntax error you're getting? I'll be able to make better suggestions if you post that.

Here are a couple things you can try/check:

1. Make sure you're actually in the bin folder when you type the mysqldump command on the command line.

2. Try this in case you don't have a password set for the user

mysqldump --user username database01 > data.sql

wombatman · 07-19-2006, 01:44 PM

The syntax error is: "You have an error in your MySQL syntax; check the manual that corresponds to your MySQL version for the right syntax to use near 'mysqldump --user root --password=(mypasswordhere) database01 > sql.dump' at line 1."

I am in the bin folder to start with.

And I get the same syntax error with your second suggestion. The error appears to be related to using a reserved word. Would a username of "root" be a problem there?

captobvious · 07-19-2006, 08:14 PM

It sounds like you might be trying to run the command from the MySQL shell, instead of the Windows command line. If your prompt looks like this:

mysql>

then you're in the MySQL shell. That would explain why you're getting a syntax error. It's expecting SQL statements.

mysqldump is a separate program, so you just need to run it from the Windows command line. Your prompt should be something like this, depending on where MySQL is installed:

C:\mysql\bin>

Hope that works for you.

wombatman · 07-21-2006, 04:15 PM

Worked beautifully. Once again, this board does not fail to help out. Thanks again (and I'm sure I'll be back with some newbie PHP/MySQL questions).

captobvious · 07-21-2006, 09:28 PM

I'm glad it worked out for you. If I've learned anything from my experience with PHP/MySQL, it's that there's always more to learn about it.

07-18-2006, 09:01 PM	#1 (permalink)
wombatman Insane	[PHP] Importing into GoDaddy's MySQL system I have a database with one table that I've done up on a local version of MySQL. I would like to move this database onto a hosting account with GoDaddy. I cannot, however, find a way to simply upload/import the database, as opposed to having to redo all the scripting. There is an option to import a text file, but they give no specifications as to what the text file needs to contain to import correctly (and when I tried a text file of just the column names and the column data, it failed miserably). Any help with this would be greatly appreciated.

07-18-2006, 10:38 PM	#4 (permalink)
captobvious Insane Location: Somewhere	What is the syntax error you're getting? I'll be able to make better suggestions if you post that. Here are a couple things you can try/check: 1. Make sure you're actually in the bin folder when you type the mysqldump command on the command line. 2. Try this in case you don't have a password set for the user mysqldump --user username database01 > data.sql Last edited by captobvious; 07-18-2006 at 11:12 PM..

07-18-2006, 09:41 PM	#2 (permalink)
captobvious Insane Location: Somewhere	It's most likely looking for a text file with a sequence of SQL commands. That's what a backup of a MySQL database is anyway. Fortunately, there's a utility that comes with MySQL that generates this file for you called mysqldump. Here's the command to use it: mysqldump –-user username –-password=password databasename > data.sql You should replace the values in italics with your info. That command will dump everything from the databasename you specify into the "data.sql" file. This is the text file you should try importing to your account on GoDaddy. For a more detailed explanation, check out this article. Hope that helps.

07-18-2006, 10:01 PM	#3 (permalink)
wombatman Insane	Well, unfortunately, mysqldump does not seem to want to work. I tried it using your (and the article you linked's) syntax, but when I try to execute the command, it gives me a syntax error. I checked to make sure mysqldump was in the bin folder, and it is. I also tried "mysqldump --opt database01". That also gave a syntax error. I'm sure I'm missing some blatantly simple thing, but I can't figure it out for the life of me. The fact that it's 2AM probably doesn't help. Any further ideas as to why I'm getting this error?

07-19-2006, 01:44 PM	#5 (permalink)
wombatman Insane	The syntax error is: "You have an error in your MySQL syntax; check the manual that corresponds to your MySQL version for the right syntax to use near 'mysqldump --user root --password=(mypasswordhere) database01 > sql.dump' at line 1." I am in the bin folder to start with. And I get the same syntax error with your second suggestion. The error appears to be related to using a reserved word. Would a username of "root" be a problem there?

07-19-2006, 08:14 PM	#6 (permalink)
captobvious Insane Location: Somewhere	It sounds like you might be trying to run the command from the MySQL shell, instead of the Windows command line. If your prompt looks like this: mysql> then you're in the MySQL shell. That would explain why you're getting a syntax error. It's expecting SQL statements. mysqldump is a separate program, so you just need to run it from the Windows command line. Your prompt should be something like this, depending on where MySQL is installed: C:\mysql\bin> Hope that works for you.

07-21-2006, 04:15 PM	#7 (permalink)
wombatman Insane	Worked beautifully. Once again, this board does not fail to help out. Thanks again (and I'm sure I'll be back with some newbie PHP/MySQL questions).

07-21-2006, 09:28 PM	#8 (permalink)
captobvious Insane Location: Somewhere	I'm glad it worked out for you. If I've learned anything from my experience with PHP/MySQL, it's that there's always more to learn about it.