• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

Hosting and moving a MySQL database...Update: Question about reseller accounts

Oooh. Cross-posting. In different forums no less. 😉

Moving a MySQL database is really simple. How are you getting the mysql dump? From the commandline or through the Invisionboard admin interface?

Rob
 
Originally posted by: Entity
Oooh. Cross-posting. In different forums no less. 😉

Moving a MySQL database is really simple. How are you getting the mysql dump? From the commandline or through the Invisionboard admin interface?

Rob
Click to expand...

I can do it either way...I can export from the phpMyAdmin screen and export in .CSV or SQL mode (with complete inserts or extended inserts and can include DROP DATABASE) or I can do the host-specified backup.
 
Originally posted by: conjur
Originally posted by: Entity
Oooh. Cross-posting. In different forums no less. 😉

Moving a MySQL database is really simple. How are you getting the mysql dump? From the commandline or through the Invisionboard admin interface?

Rob
Click to expand...

I can do it either way...I can export from the phpMyAdmin screen and export in .CSV or SQL mode (with complete inserts or extended inserts and can include DROP DATABASE) or I can do the host-specified backup.
Click to expand...

You apparantly know what you're doing... so what do you want comments on? 🙂
 
How about just using mysqldump? That way you will be able to import it into a new database.

mysqldump ..options.. database > db.sql
and then just import it on the new database with
mysql ..options.. < db.sql

Is it just me or is yagt.org not working?
 
Originally posted by: conjur
Well, I can do the Export but it's the restoring I'm unsure of.
Click to expand...

It's really easy. If you export it as a SQL file, you just do something from the commandline like:

mysql -u USERNAME -p PASSWORD DATABASENAME < filename.sql

Rob
 
Originally posted by: conjur
Well, I can do the Export but it's the restoring I'm unsure of.
Click to expand...

You can do that through PHPmyadmin - the query box gives you the option of selecting a file to read the SQL commands from (definitely set it up on the new server before killing the database on the old one though)
 
I think it's going now...trying to upload like 13.5MB at 128kbps...gonna take a while 😉


<--- off to grab a :beer: (Guinness)
 
Crap...no shell access on the acct...says I need to contact support.

And, the import is timing out after 5 mins. Gonna try something else.
 
Do it piece by piece - there's a limit to the size of files you can upload to the webserver via http (depends on the server - you could set up a script that calls phpinfo() to find out what the size limit is on your server, but it's probably about 2 MB).
 
Also, since you're apparantly moving forums, make sure you copy all of the custom avatars and skins and whatnot to the new server
 
Originally posted by: mugsywwiii
Also, since you're apparantly moving forums, make sure you copy all of the custom avatars and skins and whatnot to the new server
Click to expand...

Correct and I can help you conjur with that, do you have AIM or MSN?

Do you have SSH access on your thrillhost account?
 
Got the MySQL moved over...then I realized I'd moved it to conjur.com and not yagt.org.

DOH!

5-10 more mins. and I'll have MySQL data moved to the PROPER location. Then I just have to restore the yagt directory structure.


RossMAN, I don't have AIM nor MSN Messenger...just Yahoo.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top