SMF Support > Server Performance and Configuration

How do I import a fresh database to my test site?

(1/3) > >>

Groovystar:
My programmer doesn't know how to do it and neither do I but he says he needs a new database to test it on. Not the code file but the data in the data base tables.

What would we do to start setting it up? I'm so stuck...

pixelated:
To clarify:

I don't want to muck things up by going in half cocked and hitting problems as they arise.

I want to (at least) replace the tables that are included in topics (_messages and _topics, I think?) so I can test to make sure a fix I made worked.

Essentially, something crazy happened that *appeared* to shoot multiple threads from where they were to the trash (using the MoveTopic2 function in subs-post.php, I believe). I may be chasing a ghost, but if this happens to the live server...Well, fill in your favorite [bad stuff] phrase here.

further clarification:

This would be taking a backup of the database/tables from the live system and putting them in the test system we have setup.

~Pixelated

Groovystar:
And it has 26,000,000 posts.

青山 素子:
Importing a database backup is pretty easy. Make a backup of the data with a server-side tool like mysqlbackup at the shell (don't use the in-SMF backup feature, you're too big for it), then restore it into a different database. If you need help, contact your hosting provider, they should be able to show you the steps needed for their specific control panel.

tumbleweed:
If you are needing a copy of your "live" database. Just pop into phpMyAdmin and create a copy :) If you do not have phpMyAdmin Ask you host to create the copy they can also do it in Root.

Navigation

[0] Message Index

[#] Next page