CODEWITHSUNDEEP
mysqldatabase
molleman
molleman

Reputation: 2946

How to put a local database onto a server?

I have a mysql(v5) database running on my computer in college,

how do i go about placing this database onto a server?

if there is a way to export the schema and recreate the database that would be handy.

if i could put all the information from the database that would be a plus,

Upvotes: 0

Views: 5630

Answers (2)

Chris Ledet
Chris Ledet

Reputation: 11628

Dump the database into a file:

mysqldump -u username -p dbname > dbname.sql

now import the sql file using:

mysql -u username dbname < dbname.sql

make sure to place username with the actual username, maybe root for instance.

Upvotes: 2

Jason Kaczmarsky
Jason Kaczmarsky

Reputation: 1686

Log into phpMyAdmin and select the DB you want to export. Click on the export tab on the top and make sure "Save as File" is checked towards the bottom. This will allow you to save the entire schema and contents of the DB. You can then import the data by using the import tab and selecting the file you saved.

Upvotes: 0

Related Questions