My host accdiently deleted my MSQL, but I've magnaged to save a .sql file of it.
I was wondering, how can i get it back up? I copy and paste the content (it was over 11mb) but it says table dropped diasbled?
does anyone know what to dio?
you need to restore the db... either with a tool like phpmyadmin (http://www.phpmyadmin.net) or from shell.
mysql -u dbusername -p dbname < backup.sql
dbusername = your mysql username
dbname= the name of the database
backup.sql = the name of your mysql backup file
ahmmm... I assume that you mean MySQL and not MSQL
Yes, sorry lol typo
When I upload the file it sometimes says tables dropped or something, so I erased that line.
Now, when I upload the .sql (the size is 11mb) it takes a while.
But when the page refreshes, it's either cannot find or a blank page?
My site is hosted on servage? if that changes anything.
large databases often cannot be restored using phpmyadmin cause restoring times out. Means a web based tool won't be able to help you (there's one tool, but I think it can't restore phpmyadmin dumps)
And you're not supposed to changed the backup file. If you remove the 'drop' line, then you need to manually epty the database before a restore. With that line MySQL 'drops' the table before creating it new with the data stored in the backup file.
Use the shell command (as I've written above) or ask your host to restore your db
I dont know much about shell.
I read above, but where do i start and all? Sorry i'm a beginner at this :)
Quote from: Stramm on April 29, 2006, 01:00:21 PM
ask your host to restore your db
go for option 2 then, as Stramm suggested.
Is it possible for another alternative?
Instead of uploading the one big .sql I can copy and paste it separetly into thoes different categories on the side of myphpadmin, will that work?
yes, you could paste sections of the dump into phpMyAdmin's sql field as well