SQL Database Issues

[Nelson58]

This issue comes up again and again.

I don't know how to program SQL databases, but there are times I need to replace values in the current database with those in a backup. For example, a mod recently went bad, I re-installed it, and lost all the values. But I have a backup.

Can one of you SQL experts please tell me how to replace the values in the current database with those from a backup in phpAdmin so that I can restore my information?

Note: phpAdmin will NOT upload a table over 50M, so if I export a table larger than that from a backup, I will not be able to import it in phpAdmin. I already tried that!

I REALLY need to know how to do this!

Thanks very much!

Nelson

[findingpeace]

Hey Nelson, if you have PHPMyAdmin, I'm assuming you also have some sort of cPanel software? If so, I've found those to be the easiest way to restore databases.

[Nelson58]

I don't want to restore the whole database. I know how to do that. I want to put certain tables from a backup database into the current database. The tables are over 50m so the import function in phpAdmin doesn't work.

[findingpeace]

Contact your hosting provider and ask them to increase the following variables in php.ini, as required:

upload_max_filesize
memory_limit
post_max_size

If you do your own hosting, you'll need to restart the server for the changes to take effect.

[betterthanyours]

Hi, if you are on shared hosting, the best option would be to provide your host with the backup and specify which tables to restore considering the threshold of uploading tables are set to relatively low.

Otherwise if you are hosting dedicated or VPS then do as specified above which should enable you to complete the job.

[Nelson58]

We're on VPN but they won't go above 64m. I will have to ask the provider to restore the tables from the backup into the current database.

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

I gave the host the tables to restore in the backup database, and they did it for me. It worked very nicely (thank goodness I backed up!).

They said they did a "table dump" first then zeroed the tables to be replaced then copied the others.

Anyone know how to do that, and if so, could you explain it to me?

Thanks.


Nelson

[Nelson58]

Received in PM:

"Hi Nelson,

Is this a paid request?

We provide a monthly maintenance service, that's why I want to know.

Regards,
Claudio "

No Claudio, it isn't a paid request, and it wasn't posted in the paid request area. Please do not send me a PM for your paid services. I don't think solicitations are allowed.
-----------------------------------------------------------------------------------------------------

Back to what I need:

Here is an example:

Someone's important thread gets ruined somehow- part of it is lost. If I go back to a backup of the SQL database that I made a month ago, it is intact.

The question is, how would I go about MERGING the old thread that is intact with the current database where it is not- if this is possible?

Thanks.

Nelson