Changed providers, having problems

[shunut]

I was having a lot of problems with my provider/host so I decided that I should switch to a different provider. Probably should have stuck with the provider that I usually use but I thought I'd try someone else to see if they were any good, then I'd have an alternative to the usual one. Unfortunately, the server that my database was on was down about 75-80% of the time my forum was on there so it just wasn't working. Before I switched everything over I created a backup file of my forum, thinking that I could just reinstall the forum on the new provider's server and restore everything. So I did that but now there a somethings missing and I'm wonder if this is typical or if its not, how I can restore these items. All my users and posts are gone, they are the only things that did not transfer. Is there anyway to get them back?

Did you move the actual database from your old host? You need to move the files, AND the actual database by dumping the db on your old server, creating a new one on your new server and importing the dump of the DB into it. It sounds like you just moved the files.

https://vborg.vbsupport.ru/showthread.php?t=106935

[fatal1980]

You need to make sure that you got the whole database, sometimes if you're using phpmyadmin it won't dump the whole file because of php limits, memory, postmax, and such. It's best to just get the host to dump it for you if they can using mysqldump. You could also just grab a php script that does a "exec/system('mysqldump". Thats if you have access to the old provider.

[shunut]

All I have is the back up file. I'll have to see if I can figure out how I can get the DB. Its still there because my hosting plan hasn't expired with them yet, just not sure if its possible to do.

^ Good advice. PHPMyAdmin will almost always time out on decent sized databases. If you have shell access to your old host, run this command, changing the colored text to your info.

mysqldump --opt -u dbuser -p dbname > (path)/backup.sql

If you don't have shell access, ask the old host to do it for you - they almost always will. Once you have the output file created, you'll need to upload it to your new server and import it into a fresh database, using this command:

mysql -u user -p dbname < (path)/backup.sql

Again changing the colored text to your credentials. That will import your old database into your new database on your new host, and then you'll just need to edit config.php to point at the new database and you should be good to go if everything else (the files) transferred correctly.

Keep

--------------- Added [DATE]1223521611[/DATE] at [TIME]1223521611[/TIME] ---------------

Originally Posted by shunut

All I have is the back up file. I'll have to see if I can figure out how I can get the DB. Its still there because my hosting plan hasn't expired with them yet, just not sure if its possible to do.

What created the backup file? Did you just FTP everything down, or did your host create it for you? If you have SSH access to the old host you can dump the DB yourself. If not, as long as you haven't deleted your database on the old host you should have no problem getting it.

If you don't have SSH access to your new host, or don't feel comfortable, you SHOULD just be able to upload the dump file from your hold host to your new server and contact your new host to have them import it for you. It's a simple process and if their support is even half decent they should have no problem taking care of it.

[shunut]

My old host has a chat program so I jumped on there and asked them how I can get it. They put a full back up file on my FTP site, so I could download it. The backup file that I was working from previously was the backup created by vBulletin.

Its not wanting to download to my computer now for some reason, so we'll see if I can get it.

Okay, I got it now. Not sure why but it wouldn't let me download the file via FTP. I had to go into my control panel and download it from my file manager. Its on my computer now so thats the important part. So now I should be able to restore the database like I did through phpMyAdmin, like I did before?

You can try, how big is your database?

SSH is really a much cleaner, better way to do it.

[shunut]

Its actually a very small forum and database, the actual file size is 5.80 MB. I would love to do the SSH method but I have no idea what it is or how to do it. I saw it on the phpMyAdmin choices, guess I'll have to do some research.

NVM: I saw the SSH thing here:

https://vborg.vbsupport.ru/showthread.php?t=106935


Still going to research it a bit and see what I can find.



edited:

I got it to work!!! I didn't do the SSH thing, because honestly, I didn't understand it. Since the file wasn't too big and was under the maximum size denoted in phpMyAdmin, I figured I'd give it a shot. The file uploaded fine and everything it back to normal.

Thank you so much for all the help!