Mysql Db Restoration

[ccplim]

Hi,

 

I am new to this forum and this is my first time posting here. Not sure if this is the correct place to post?

 

Anyway, I am currently working on upgrading my forum software (in testing stage) and will need to restore my database a few times at different stages of the upgrade due to the various versions involved.

 

How can I do that without any Telnet/SSH access? I have the intention of applying for SSH access but was worried that my application would be rejected. If given the worst case (application was rejected), what is the best way to perform the various restore?

 

By the way, I have my database backed up in .sql format.

 

Any kind helps are greatly appreciated.

 

Thanks!

[TCH-Mark]

Hello,

 

You can restore the database from within phpmyadmin using the import facility and you can also take a backup of your database from within cPanel backup facilit which will allow you to download a .sql backup of your choosen database, if I remember correctly you can also restore a database from the backup of section of your control panel also but doing it via phpmyadmin is better (in my aopinion anyway).

[TCH-Thomas]

Welcome to the forum, ccplim.

[TCH-Bruce]

Welcome to the forums ccplim

[ccplim]

Hi Mark,

 

Thanks for the quick reply! I had a look at the cpanel backup facility but I do have a few queries.

 

1) My current DB in .sql format is about 28MB but when I try backing up using cpanel backup, the .gz file that I received is only 4.8MB. Is that normal? (such a high compression ratio?)

 

2) I have 2 DBs at the moment. My live copy (DB 1) and a test copy (DB 2). If I perform an upload using cpanel backup facility, will it prompt me which databse I wanted to upload to? I do not want it to upload to DB 1 and mess up my live board. My intention is to restore backup copy of DB 1 to DB 2.

[TCH-Andy]

Welcome to the forums

 

You can also upload the .sql file to the server, and ask us to restore it for you if you have problems.

 

Yes, I would expect such a high compression ratio

 

Yes, it will prompt you for which database through php. For cpanel, it goes by the database name.

[ccplim]

Welcome to the forums

 

You can also upload the .sql file to the server, and ask us to restore it for you if you have problems.

 

Yes, I would expect such a high compression ratio

 

Yes, it will prompt you for which database through php. For cpanel, it goes by the database name.

 

Hi Andy,

 

I did thought of that but as I am currently performing some testings and will be restoring the database a couple of times at various stages, I thought it will be easier for me to be able to do so at my own most convenient timing instead of asking you guys to do it everytime.

 

And thanks for the warm welcome everyone

[TCH-Don]

Welcome to the forums

you can always copy db1 to another folder on your computer and rename it to db2

and then upload it in cpanel > backup

As this is so compressed it will be faster than using MySqL

[TCH-Rob]

Welcome to the forums ccplim. Nice to see you aboard.

[stevevan]

Welcome to the forums!

[ccplim]

Thanks Don, Rob, and Steve for the welcome

 

Don, that sounds like a good idea. I will give it a try.

[ccplim]

(Please move this post to it's appropriate forum if it is not meant to be here)

 

I have some doubts which I need some clarification. I have done a search and came across some postings saying that if we really need SSH access, we can submit a ticket stating our reason but this will be subjected to approval.

 

Is there really such a procedure?

[TCH-Andy]

Shell (SSH) access was stopped a couple of years ago, so there is no longer a procedure for gaining shell access.