>> Site Map >> Forums >> phpBB Module
Forum module - topics in forum:
phpBB Module - Discussions relating directly to the PHP-Nuke phpBB module.
Restore database problem
I am currently rebuilding my site on a new server and have nuke platinum 7.6.0 installed on both ..
When i try restoring database on new servr i get this error
Error importing backup file
DEBUG MODE
SQL Error : 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 '
Any ideas
And you are doing this where?
The only place you can restore a db backup is via phpmyadmin.
If you are trying to do this through the phpbb backup section it aint gonna work.
The error you posted is not complete. What does it tell you more. Which line is causing this?
BL
| BlueLion Wrote: : |
| The error you posted is not complete. What does it tell you more. Which line is causing this? BL |
that is the exact quote.. it doesn't say what line is a fault..
I made a backup from phpbb backup section on site A and tryed to restore in the same on site B.
I dont want to restore the whole site , just the forums..
Is there an idiots guide to this some where
: :Where are you trying to do this? Admin / Forums? That doesnt work - the only place you can do restores of ANY tables is in phpmyadmin.
| Quote: : |
If you are trying to do this through the phpbb backup section it aint gonna work |
So how do i do this then...
Backup from.... using ..... and what sort of backup
I have made plenty of backup's with phpmyadmin but never had to use them before..
You restor by using the sql tab and browsing for your backup file you made...
ERROR: Unknown Punctuation String @ 269
STR: />
SQL: #
# phpBB Backup Script
# Dump of tables for lecro_pn
#
# DATE : 23-09-2005 20:53:53 GMT
#
#
# TABLE: auth_access
#
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<!-- link rel="stylesheet" href="../templates/subSilver/subSilver.css" type="text/css" -->
<style type="text/css">
<!--
Third time lucky.....
| Quote: : |
If you are trying to do this through the phpbb backup section it aint gonna work. |
MySQL said: Documentation
#1050 - Table 'nuke_bbposts' already exists
Forums still say forum had no posts..
Like i said i never done this before and really need an idiots guide
You need to backup using the export function in phpmyadmin and then restore using the sql function.
During the export check the add drop table button and it will stop errors like
| Quote: : |
#1050 - Table 'nuke_bbposts' already exists |
