Database to new host

[zosman]

I have a current live forum now, and wanted to move to a new server. i have done a fresh new install on the new server. But now the new fresh forum on new server is basically new without posting. Can i bring the members and posting database over to the new server ...just the members and posting is what i need. can i do that?

[Sarge]

Have you checked in the Online Manual?
Saving/Restoring, and Moving SMF From a Host to Another

[zosman]

i try to read this

[6.5] How can I restore (upload) my database or table using a dump? How can I run a ".sql" file.

Click on a database name in the left frame, the properties will be local displayed. Then in the "Run SQL query" section, type in your dump filename, or use the Browse button. Then click Go.

and not sure which is which theres no RUN SQL query

[zosman]

Sarge are u able to assist me with the database dump thingy. i will give u a free host hehehehehe

[zosman]

hi guys i really need help in this database migration

[babjusi]

Have a look at this topic, it will tell you how to restore the database in different ways

http://www.simplemachines.org/community/index.php?topic=184356.msg1172622#msg1172622

[Sarge]

In recent versions of phpMyAdmin, the "Run SQL query (file)" section is under the Import tab. Select your database on the left side of the screen, if it's not already selected, and then click on the Import tab.

Click on the picture to see it in full size:



Select your .sql, .sql.gz or .sql.zip dump file and then click the Go button at the end of the screen.

Notes:
1) The maximum file size allowed depends on your account/server configuration. It is the maximum size for the uncompressed (.sql) file, even if you have compressed it to .sql.gz or .sql.zip.

2) If some posts on your forum have international, non-English characters (à, ß, é, Ш etc.) or other special characters, and they don't show correctly in your forum after the import, try selecting another character set -- the most common ones are latin1 and utf8.