I am unable to use telnet to switch servers and am using phpmyadmin instead. Would anyone have the proper way to save the database and upload it to the new server, as I have no clue how to use this program?
Dump of database
Collapse
X
-
Re: Dump of database
Originally posted by Glock21
I am unable to use telnet to switch servers and am using phpmyadmin instead. Would anyone have the proper way to save the database and upload it to the new server, as I have no clue how to use this program?:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ] -
He is unable to at the moment, and we are switching on a different server, same host. I would like to at least use phpmyadmin for a trial to see if the forum works on the new server correctly. My database is small and it shouldn't timeout likely.Comment
-
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 ?
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
Code:mysql -u mysqlusername -p newemptyvbforumdatabasename < /home/username/public_html/tablename.sql
do the same for each tablename.sql file
or if you have to use phpmyadmin you need to import each sql table file in to a new empty vB database:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]Comment
-
Originally posted by Glock21
What about in the VB CP Import & Maintenance
Back-up Database SQL Dump of data:, is that the same thing? And also if I checked every table, and save as file wouldn't that also work equally? If only we had telnet...:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]Comment
-
both vB backup and phpmyadmin are php scripts subject to the same timeout issues
in phpmyadmin stats what total size of your vB database does it report before backing up ?:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]Comment
-
I have no choice but to use phpmyadmin
To do my backups(data base size=7meg)
So are you saying that If you use this method your not getting compleat backups??
It seems to work fine.
Thanks for any info
CheersComment
-
Originally posted by jmd
I have no choice but to use phpmyadmin
To do my backups(data base size=7meg)
So are you saying that If you use this method your not getting compleat backups??
It seems to work fine.
Thanks for any info
Cheers:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]Comment
-
Also, I'm not sure if I understand exactly how the transfer works. Do I have to install vBulletin again on the new server, or does it automatically transfer once the old database is installed? Do my hacks and custom files also get transferred?Comment
-
You have to transfer your existing vB files to the new server. No need to reinstall.Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
Change CKEditor Colors to Match Style (for 4.1.4 and above)
Steve Machol Photography
Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.
Comment
-
Originally posted by Glock21
If I just download them all, and reupload to the server will everything be setup correctly with Chmods and what not?:: Always Back Up Forum Database + Attachments BEFORE upgrading !
:: Nginx SPDY SSL - World Flags Demo [video results]
:: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]Comment
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Comment