How to put a local database onto a server?

Question

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,

dev.mysql.com/doc/refman/5.5/en/mysqldump.html

zerkms
– zerkms

2011-07-26 15:00:18 +00:00
Commented Jul 26, 2011 at 15:00 — zerkms
– zerkms, Commented Jul 26, 2011 at 15:00

Chris Ledet · Accepted Answer · 2011-07-26 15:03:00Z

2

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.

answered Jul 26, 2011 at 15:03

Chris Ledet

11.6k7 gold badges42 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Jason Kaczmarsky · Accepted Answer · 2011-07-26 15:01:53Z

0

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.

answered Jul 26, 2011 at 15:01

Jason Kaczmarsky

1,6861 gold badge18 silver badges30 bronze badges

Collectives™ on Stack Overflow

How to put a local database onto a server?

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related