Pages: 1
| Posted: 21 Apr 2005 19:34 | ||
|
Registered User Currently Offline |
Posts: 1 Join Date: Apr 2005 |
|
|
Great script, lighting fast even on a virtual host and easy to set up. I'm not much of a database guy however, and was wondering about backing up the forum contents and how one would go about that?
Thanks 
|
||
| Posted: 21 Apr 2005 20:38 | ||
|
Administrator |
Posts: 1223 Join Date: Mar 2005 |
|
|
Most hosting companies provide you with a control panel where you control various things on your site. Usually, there's site/mysql backup utility. This utility produces a single file. If sth goes wrong, you can recover the db from that file.
Use the mysql backup provided with your hosting account. Also, backup all forum files (esp. the setup and templates). |
||
| Posted: 09 Jul 2006 12:10 | ||
|
Registered User |
Posts: 33 Join Date: Oct 2005 |
|
|
I recently changed hosting companies and exported the DB. Now when I try to import the DB to new host, I get the following messege:
Code:
Error SQL query: -- phpMyAdmin SQL Dump -- version 2.7.0-pl2 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: Jun 29, 2006 at 06:08 AM -- Server version: 4.1.18 -- PHP Version: 4.4.2 -- -- Database: `seo_board` -- CREATE DATABASE `seo_board` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL said: Documentation #1064 - You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci' at line I am not sure what happened during the export, but it looks to me that the language was changed. Can this be edited so that I do not have to manually enter the info from my backup? I don't really have any experiance with databases. |
||
| Posted: 09 Jul 2006 16:21 | ||
|
Administrator |
Posts: 1223 Join Date: Mar 2005 |
|
| When I migrate mysql db's I create the new database myself, and then import everything else. Just remove the create database, make the db by yourself and try importing the rest of it. | ||
| Posted: 10 Jul 2006 13:06 | ||
|
Registered User |
Posts: 33 Join Date: Oct 2005 |
|
 THANKS!
That worked great! Forums are back up and running. |
||
Pages: 1
