 | View Full Version : How do you install your backup MySQL DB?!?! Z400Central 02-12-2003, 01:56 AM I just downloaded my mysql DB, and now im trying to upload it again...yet, IE keeps freezing, or something....i see all this text and text, and it just stops...Its a backup of phpbb..so my question is, do I have to recreat a DB? Or does it make it for me? And do i have to reinstall phpbb? THEN reinstall the mysql DB? :confused: thx!!! PulseHost 02-12-2003, 02:07 AM Did you downloaded your mySQL database as a .sql file from software, such as phpMyAdmin or anything else for that matter..? You may have to re-create the database itself and then do a mySQL dump into the database from the file (contents) that you downloaded or backed up.... Post details.. If possible.. Hope this helps... -Nirav akashik 02-12-2003, 02:10 AM Do you have shell access? /usr/bin/mysql *database name* -u *username* -p*password* < *name of sql file*.sql from the directory the .sql file is uploaded to. That's generally the easiest. most error free way to do it. Greg Moore Z400Central 02-12-2003, 02:15 AM Well its a .gz file.....i did a mysql DB backup within CPANEL.... Angel78 02-12-2003, 04:41 AM do it with PhpMyAdmin and backup as .cvs, then it would be easy to import huge DB's Z400Central 02-13-2003, 01:58 AM when i do it via phpmyadmin, it saves it as .sql..... how do i get it to save as .cvs? and when i want to upload this file again, how?!?! I tried doing the restore a mysql DB, and IE freezes..... okihost 02-13-2003, 02:26 AM Chances are you are getting a time out of something due to it being a large database. Just do it via SSH if you can and if not put it up on your site somewhere and ask your host to dump it for you. |