 | [Solved] phpBB Restore Database |  |
 Posted: 06/10/2007 12:13 PM |
 |
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
 |
|
|
|
Joined: Mar 31, 2007
Local time: 4:56 PM
Location: Birmingham, UK.
|
|
|
|
|
 |
What's the use of this? 
When I tried to restore the database using ACP it couldn't do it because phpBB tables already existed. I would have thought it could at least overwrite the tables or something 
Instead if I ever want to restore the database I have to goto my hosts CPanel > phpmyadmin delete the database tables then import the sql file again. Lot of messing about imo  |
|
|
|
|
| Back to Top |
|
|
| Re: phpBB Restore Database | |
| Posted: 06/11/2007 2:06 AM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:56 AM
Location: St Pete, FL
|
|
|
|
|
|
If you do your database backups from your ACP, you should be able to restore them from the ACP as well. But if you make your backups from phpMyAdmin or some other source, then the ACP Restore database option may not work as you noticed since your database backup may include structural duplications which would never be allowed. I never use the ACP backups or restore utilities. I've heard that the Retore can have trouble if the backup file is too large as well...
 |
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] phpBB Restore Database | |
| Posted: 06/11/2007 1:51 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 4:56 PM
Location: Birmingham, UK.
|
|
|
|
|
|
| Ok, I'll stick with phpmyadmin then being as it’s safer to use etc cheers. |
|
|
|
|
| Back to Top |
|
|
| Re: phpBB Restore Database | |
| Posted: 06/11/2007 4:48 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:56 AM
Location: St Pete, FL
|
|
|
|
|
|
Yes, I've come to the conclusion that the phpMyAdmin backups are better than both the ACP Database Backup and MySql-Front Export options. The phpMyAdmin export creates a smaller backup file that can be restored with fewer errors. I think it's the best and fastest way to go at this point...
|
|
|
|
|
| Back to Top |
|
|
| Re: [Solved] phpBB Restore Database | |
| Posted: 06/11/2007 4:57 PM |
|
|
|
|
|
| Citation |
| Posts |
1332 |
| Word Cnt. |
86,126 |
| BDay |
Feb 11 |
| Sign |
Aquarius |
| Sex |
|
|
|
|
Joined: Mar 31, 2007
Local time: 4:56 PM
Location: Birmingham, UK.
|
|
|
|
|
|
Ok Kewl.  |
|
|
|
|
| Back to Top |
|
|
| Re: phpBB Restore Database | |
| Posted: 06/11/2007 5:32 PM |
|
|
|
|
|
| Site Admin |
| Posts |
30757 |
| Word Cnt. |
2,628,690 |
| BDay |
Jul 28 |
| Sign |
Leo |
| Sex |
|
|
|
|
Joined: Sep 25, 2004
Local time: 11:56 AM
Location: St Pete, FL
|
|
|
|
|
|
|
|
|
|
| Back to Top |
|
|
| Information | |
|
Calendar
