Some questions regarding cPanel

[master412160]

From my understanding there are many ways to backup something from there. In the auto install script you can take a backup of the script you have installed, via phpmyadmin, and the Backup tap on the index of cPanel. If you go to there you can take a backup of the directory and selected database.

But if I always take a backup of my database there is nothing in it, and when I upload one and click restore. It just says: Restoring Database and nothing else.

 

[CyberFreak]

How are you making these backups?

 

[Watch Me Sink]

Best way to import a db (IMO) is through phpmyadmin. Make a new db with the name of your old database. Go to the import tab in phpmyadmin. Upload your db.

You may have to split up the database, depending on how much it allows you to upload at a time.

 

[master412160]

How are you making these backups?

Via the backup panel not via phpmyadmnin. Each time I backup my site I do it via backing up the directory and the database of the site. It seems though that isn't really working. as the db is empty.

Best way to import a db (IMO) is through phpmyadmin. Make a new db with the name of your old database. Go to the import tab in phpmyadmin. Upload your db.

You may have to split up the database, depending on how much it allows you to upload at a time.

It seems I have to take a backup of the directory and manaul in phpmyadmin take FROM THERE a backup of the database right ?

But its kind of hard for a guy like me who doesn't know how to work perfect with phpmyadmin. I mean there are some options and I don't know any SQL commando, I am a noob, and its best to not let a noob use phpmyadmin.

 

[CyberFreak]

To make backups ans restore backups through phpmyadmin is easy and you don't need to know any fancy SQL commands.

This is for wordpress but it shows images of how to backup up your DB - http://codex.wordpress.org/Backing_Up_Your_Database

 

[master412160]

I see, next time I will use phpmyadmin to backup.

But I got an error 2 or 1 day ago when importing a db on a database of a just installed Mybb forum but it gave an error and nothing happened.


So you can only import it into an empty db ? you just created via cPanel right ?

 

[CyberFreak]

Without the error, we can't help you with the error you got.

To restore it, create a new db in cpanel and assign a db user to it. Open up the table in phpmyadmin, select import and then select the backup file. Click go and then wait for it to restore. Edit the config file for mybb and enter the new db name, db user and password.

For the sake of this discussion, pretend you can only import it into an empty db. While that is not strictly true, it is a bit complicated to fully explain and it will just be confusing and really more then you need to know at this stage. When you actually can restore a db into a empty one we can then go into when you can and when you can't successfully restore information in an existing database that already contains information.