Backup using phpmyadmin

[Arsenik]

I dont have telnet/ssh access... I only have ftp and cpanel/phpmyadmin access to the site/db. (changing host)

I would like to know if doing a dump of the database (structure and data) using phpmyadmin a good way? will it work?

Thanks

[eva2000]

not recommended at all.. phpmyadmin and any php based backup script are subject to php timing out before completing a proper backup... you'll end up with incomplete or half done backups!

if you don't have ssh/telnet as your host to do the backup for you.. if they're not willing to do this you better find a new host or upgrade to a plan which has telnet/ssh access

[Arsenik]

I am changing/plaining to change host but i need to backup the db. No support at all is one of the reason why i am moving so i cant count on host for a thing... :mad:

Forum stats:
Members: 394, Threads: 1,219, Posts: 8,452

You think i wont get all the infos? I am going to test it anyways but your feedback is more then welcome. Do you suggest backing up the data only or should i backup the structure and data?

[eva2000]

you can try backing up each table within vB database one at a time hopefully that would work

i'm assuming you have phpmyadmin installed already right ?

http://www.vbulletin.com/forum/showthread.php?s=&threadid=18558

1. Look to your left frame, and you'll see the name of your mysql databases.
2. Click on the database name and you'll see the right frame change, showing your databases' tables, how many records, table type (MyISAM) and table size and total database size.
3. Scroll down further in right frame and you'll see a few functions such as

- a text area box titled "Run SQL query/queries on database YOURDATABASENAME"
- 'Or Location of the textfile' with the Browse and GO button
- View dump (schema) of database which lists the table names in the database in a box and to the right of the box is a few functions labeled as, 'Structure only', 'Structure and data' and 'Data only'
- below these labels are check boxes with one of them closest to the GO button being, 'Save as file'

4. to backup each database table,

select the database table name i.e.

admin table and then

check the 'Structure and data' check box and tick the 'Save as file' option and then hit the GO button, you'll be prompted to download a *.sql file which contains a backup of your database data and table structure. Remember to save the *.sql file to a folder on your pc and remember that location for import/restore purposes.

do this for each vB database table so you would select another table name in vB database and do the same thing

you will have a bunch of tabelname.sql files you need to upload to new server

5. To reimport these to an EMPTY database on new server using telnet you will have to run as many commands as the number of vB database tables you have backed up into .sql files

if you uploaded them to /home/username/public_html on new server

you'd type

mysql -u mysqlusername -p newemptyvbforumdatabasename < /home/username/public_html/tablename.sql


it will prompt you for your mysql password and wait until you come back to prompt to indicate it's complete

do the same for each tablename.sql file

[Arsenik]

Yes i have phpmyadmin and i will try going one table at a time thanks alot for your help.

[Steve Machol]

The latest version of CPanel also has a database backup and restore feature. I tested it out on my database (>60Mb) and it worked flawlessly.

[Arsenik]

It says cpanel 4.9, is that the latest version? If so ill do the backup that way then. Backing up one table at a time is so time consuming :eek:

[eva2000]

Originally posted by Arsenik
It says cpanel 4.9, is that the latest version? If so ill do the backup that way then. Backing up one table at a time is so time consuming :eek: oh you're using cpanel ? yes there's backup function in cpanel now adays

[Steve Machol]

Originally posted by Arsenik
It says cpanel 4.9, is that the latest version? Yep. The database backup option is in the Access Menu.