I have mambo installed on my site, and within it, a phpbb forum component (Basicly phpbb in a wrapper) It works ok, but due to login, updates and modification problems, i've decided to move back to a normal installation of phpbb forum, entirely separate from mambo.
In the admin panel of the phpbb forum, I can create a backup just fine (at least it seems that way)
I made a fresh install of phpbb in another location, on another database and attempted to restore there.
Problem #1 crops up. Timeup upon attempting to upload. I searched these forums, and found several posts suggesting that I ask LP to do that for me. So I did, and after they attempted such, this was their response:
Unfortunately your dump will not import as it is corrupt, please see below for
details:
thetra6_phpb1 < /home/*******/www/backup/phpbb_db_backup.sql.gz
ERROR 1064 at line 140309: 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 '
Please make the necessary modification in the phpbb_db_backup.sql file and re-upload, so that we can import the mysql database.
I had thought that since the download of the backup seemed to work, I would be able to restore this bastardized version of the phpbb forum.
LP had asked me to "make the necessary modification", but I don't know what that involves.
Also, when I check my new forum installation, it kinda worked. I had the theme, the proper forum names, the dates, the number of posts....but...no posts...or users.
LP says the backup is corrupt, so to eliminate a bad download/export I did it again, and asked them to try and restore once more.
This was the response:
Unfortunately, it does look as if your database backup is indeed corrupted. I downloaded the SQL file you had put in the backup folder and if you open it up in a text editor like WordPad and scroll to the very bottom of the file, you will see the following:
# TABLE: phpbb_users
#
What follows after that is HTML code and this is the point at which the mySQL import process breaks down. The fact that the .gz backup file you have is 13MB and the SQL file is also 13MB also suggests corruption since if the total SQL file was only 13MB, the compressed .gz file should be much smaller. I have a feeling that the .gz file itself is corrupted and you can only extract the first 13MB. I will download the .gz file next and see if this is indeed the case. In the meantime, is it possible for you to obtain a fresh backup in case this is indeed the case? Or is this the only backup you have available?
SO, backing up via admin panel of the phpbb mambo component isn't working right. So I ask advice for an alternative method of backing up DB.
We suggest make database backups by clicking the database link in the Backup area of cPanel. If you have not been taking advantage of the backup capability in Cpanel, please review these cron scripts you can setup to automate backups for your account:
http://www.lunarforums.com/forum/viewtopic.php?t=22118These should be helpful in future issues that you might have to automate
backups for you.
Please, do not hesitate to contact us if you have any questions.
I do as suggested and backup the DB in question with that method. And again, ask them to attempt a restore.
(Did I mention how awesome these guys are being? I hated to ask so much of them...I mean, I only pay them 8 bucks a month! geez)
Next response:
Unfortunally, the import of mamb1ended with following error:
*******_phpb1 < /home/*******/www/backup/mamb1
ERROR 1064 at line 498: 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 'option varchar(50) NOT NULL default '', ordering int(11) NOT
If I correctly understand you would like to copy content of *******_mamb1
database into *******_phpb1. You could to use "Copy database to:" function in the "Operations" in PhpMyAdmin.
Ahhh, the dreaded phpmyadmin. I'd previously peeked at this, and it was very daunting. I checked into it, but couldn't get the "copy database to" function to work though. As you read further though, you'll see that it probably wouldn't have worked anyway.
Around this time I discover Garvey's awesome "How to restore your hacked phpbb boards" thread. This seemed perfect! It gave me a little rundown as to the useage of tables and whatnot. I then methodicly ran all the sql queries I needed to...except, I found one to be missing. "phpbb_users" didn't exist. Apparently, since Mambo and my component installation of the phpbb forums share the same usernames and passwords it uses a table called "mos_users" I compared it side by side with what a normal "phpbb_users" table should look like, a few changes here and there, otherwise almost identical.
I attempt to modify the "mos_users" table? I attempt this, and fail miserably.
SQL-query:
--
-- Dumping data for table `phpbb_users`
--
INSERT INTO `phpbb_users`
VALUES (
-1, 0, 'Anonymous', '', '', '', 0, 1, 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, 0, 0, 0, 4, 0.00, NULL , '', '', 0, 0, 0, NULL , 0, 0, 0, 1, 1, 1, 0, 1, 0, 1, 0, NULL , '', 0, '', '', '', '', NULL , '', NULL , '', '', '', '', '', '', ''
)
MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1
And this is where I am. Column counts? Values? Arrgh. Everything I know about DB's and tables I learned mucking with this in the last few days.
Am I going about this the wrong way? Any help is greatly apreciated. Thanks.
