Restore Database

Demo mode
You are browsing phpBBHS control panel in demo mode. Most functions are disabled, some data has been replaced with dummy data and you cannot edit anything.

Restore Backup
Forum:	testphpbb
Location of SQL file:
Prefix in SQL file:	phpbb_ testphpbb_ Custom:
Additional SQL file (optional):
Prefix in second SQL file:	phpbb_ testphpbb_ Custom:
Options:	Ignore errors. Abort import after 100 errors. Make sure all tables exist before finalizing db restore. Do not use temporary tables during restore and restore to live forum (use this option ONLY if you don't have sql permissions for "RENAME TABLE" and if backup contains "DROP TABLE" queries).
Notes:	* Second sql file will be restored after first one. That function can be used to automatically run sql queries to install custom mods or upgrade forum. * Make sure backup is compatible with phpBB version you are using. * When restoring backup, script will make temporary tables instead of overwriting live forum and will move those tables to live forum only when restore has been successful. * If there are many tables and lots of data, script might take a while to process it and sql server load might go up. * Path to file should be relative to "hs" directory or absolute. Do not use urls. * Variable {FORUM} in backup filename will be replaced with forum name ("phpbbhs" for phpBBHS tables). * Variable {DB} in backup filename will be replaced with database number. * Variable {ID} in backup filename will be replaced with forum ID. * Variables {ID2}, {ID3},... {ID6} in backup filename will be replaced with forum ID using 2-6 digits ("00" - "00000" for phpBBHS tables).