upload db?

[Sul]

Hi

Is it possible to build a database on a local mysql server, and then upload it to the webserver? If so, how do I do it?

Thanks

[Darkness22k]

If you're using phpMyAdmin, then you can by using the export button. 🙂

[LordShryku]

The non-GUI way would be LOAD DATA INFILE

[superwormy]

Another not GUI way for MySQL:

mysqldump ( to dump the database )

mysql and then the 'source' command ( to load the database )

[Sul]

I'm interested in the non-GUI commands.

So, mysqldump will export the database to a file, and then source will import it?

What if I just want to import just data?

[superwormy]

mysqldump dumps SQL commands which vary depending on which command line options you set. You can tell it to dump specific databases, tables, just data, just structure, all kinds of other function options, and just pipe it ( | ) to a .txt file.

the 'source' command in the mysql command line utility simply opens a txt file, and runs any line as an SQL statement.

[Sul]

Okay...this is all confusing me.. 🙂

This is what I want:

I'm creating a database locally (with data in it). I want to export the entire database and import it into a mysql server online.

How do I go about doing this? I really have no idea. Please help.

Thanks

[LordShryku]

Using mysqldump, assuming you want to dump all databases...

local computer
/path/to/mysql/bin/mysqldump --all-databases -h $HOSTNAME -u $USERNAME -p$PASSWORD > backup.sql

This dumps all databases into a text file called backup.sql

On the remote computer, you should be able to issue the same command, only using a < instead of a >. This tells it to load the file into the database, instead of the database into the file....

If you lookup mysqldump in to the manual, you'll see that there's a ton of options to pass to it, so you can customize the command to fit your needs.