MyBB Community Forums

Full Version: Name of directory/file(s) for database file/s ?
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
What should be the normal name of the directory/files(s) holding the database file/s ?
Ie when backup the database to...
Quote:/var/www/forums/admin/backups/backup_5e78d14c26X5psBss9p6qCRSDxduBMpOmwCObcjncFdjg9eIS55CWqw8XFEusF93.sql (Download)
Where does that info go when 'restore' ?
Ie...
Quote:Database Restore
To restore a database, you click the SQL tab (on newer versions of phpMyAdmin there is an "Import" tab).
On the "SQL"-page , unclick the show query here again.
Browse to your backup of the database.
Click "Go".
Log into your SSH/Telnet account.
Have your .SQL dump/backup ready, extracted from the .gz backup that you made via the Admin CP or from phpMyAdmin.
You may have to drop all tables from the MyBB database first, because the Admin CP backup SQL doesn't include DROP TABLE statements. You can do that with the following command line. Type your MyBB database password when prompted.user=YOUR_MYBB_DB_USER; db=YOUR_MYBB_DBNAME; mysql -u $user -p -BNe "show tables" $db | tr '\n' ',' | sed -e 's/,$//' | awk '{print "SET FOREIGN_KEY_CHECKS = 0;DROP TABLE IF EXISTS " $1 ";SET FOREIGN_KEY_CHECKS = 1;"}' | mysql -u $user -p $db.
Run mysql -u YOUR_MYBB_DB_USER -p YOUR_MYBB_DBNAME < /PATH/TO/DUMP.SQL
Is the name in there someplace ? Confused