Cont Restore Database

[dan0042]

I Cont Restore Database got my db file , go acp Restore Database Upload phpdb and Dont see forums goin back to that old db ,
68.4 MB without Gzip compression
mysql server are in 4.x.x version

[Drop-Forged]

[url=http]Click Here[/url] for a script that will help you get past the 50 MB limitation of your server.

[dan0042]

[url=http]Click Here[/url] for a script that will help you get past the 50 MB limitation of your server.

Thanks for reply mate ,what do with this ?

[Drop-Forged]

It is called bigdump, and for importing large MySQL dumps into a database by inserting the info in smaller batches, as to not be restricted by the 50 MB limit.


Open the bigdump.php with a text editor, insert the à¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€¦Ã¢â‚¬Å“Database configurationà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€š

[dan0042]

Forbidden
You don't have permission to access /bigdump/bigdump.php on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
?

[dan0042]

BigDump: Staggered MySQL Dump Importer ver. 0.24b
Processing file: phpbb_db_backup.sql

Starting at the line: 6508

Error at the line 9392: );

Query: CREATE TABLE phpbb_fc_dstore( uid varchar(255), name text, value text, enteredtime timestamp DEFAULT 'CURRENT_TIMESTAMP', id int(11) NOT NULL auto_increment, PRIMARY KEY (id), KEY nameidx (name) );

MySQL: BLOB/TEXT column 'name' used in key specification without a key length

Stopped on error

[dan0042]

Hello Daniel,

As I mentioned in my previous posts:

Unfortunately I was unable to import the mysqldump you've provided us with. So please re-export your database again, but please be sure that you use the backward compatibility option, because our MySQL version is 4.1.21-standard-log.

[dan0042]

just went my website this come up phpBB : Critical Error

Could not connect to the database

[Drop-Forged]

Im definitely no expert, but I think you have an SQL error in your database backup.

The only way Ive ever been able to get around this in the past was to manually remove the query with the error in the backup.

Maybe someone who knows more than me knows a better wayà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦ <img>

[dan0042]

The only way Ive ever been able to get around this in the past was to manually remove the query with the error in the backup.


Info onthat ?

[dan0042]

wont Restore Database ,Becausse My admin N00bKicked one my Members Sorry, but that user does not exist, Isway that i can pull her name out back-up db and add in one runnin now ,

[IntegraMOD]

look in phpbb_users for her detail and export that and then add it to your new database

[Drop-Forged]

So you just want to restore an account, not the whole database??? <img>

[dan0042]

So you just want to restore an account, not the whole database??? <img>

yep, just one account

[IntegraMOD]

Ok to add just one account could you not just re-register this person?

If not then you will need to look in your phpbb_users table and find the account details for the person you want to add, then you will need to insert them into the database by running an sql query from phpmyadmin.

the query will look something like this.

Code: Select all

 INSERT INTO `phpbb_users` VALUES (4,1,'test','ae2b1fca515949e5d54fb22b8ed95575',1160765824,-13,1160757856,1159638537,0,0,'1.00',5,'english','d M Y h:i a',0,0,1160252345,NULL,1,1,0,1,1,1,1,1,1,0,1,0,1,0,NULL,0,'email@address.com','','','','','','','','',NULL,'','',NULL,NULL,'',0,'19680102',0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,15,5,1,1,1,2,2,1,1,1,1,1,0,7,1,5,1,1,3,3,3,1,1,1,1,1,0,2,'1160271649;4:0',15,NULL,2,0,1160263943,0,0,1,2,0,0,0,0,'0','5','559a7f208866f0063b1ea8d5ca2ee816','cats name',0,0,0,0)  

[font=Arial Black:1e4g8u05][color=red][size=99px]

You can also split the database up into smaller section with wordpad, just open the database file and cut and paste in into smaller parts and save them as part1 part2 and so on them run them and sql queries in phpmyadmin this will also help get over the 50Mb limit

[dan0042]

Open the backup file in a text editor
Nearly every line ends with a ;. These are the points where you can split the file. Simply copy/paste everything after a specific ; into another file

Is this right whatthey sayin there ?

[dan0042]

INSERT INTO `phpbb_users` VALUES (4,1,'test','ae2b1fca515949e5d54fb22b8ed95575',1160765824,-13,1160757856,1159638537,0,0,'1.00',5,'english','d M Y h:i a',0,0,1160252345,NULL,1,1,0,1,1,1,1,1,1,0,1,0,1,0,NULL,0,'email@address.com','','','','','','','','',NULL,'','',NULL,NULL,'',0,'19680102',0,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,15,5,1,1,1,2,2,1,1,1,1,1,0,7,1,5,1,1,3,3,3,1,1,1,1,1,0,2,'1160271649;4:0',15,NULL,2,0,1160263943,0,0,1,2,0,0,0,0,'0','5','559a7f208866f0063b1ea8d5ca2ee816','cats name',0,0,0,0)

cont i look in db file for this ?

[IntegraMOD]

yes that was what I was saying look in the database and then run that as a single query on your current database.

[IntegraMOD]

Open the backup file in a text editor
Nearly every line ends with a ;. These are the points where you can split the file. Simply copy/paste everything after a specific ; into another file

Is this right whatthey sayin there ?

If you look for this....

-- --------------------------------------------------------

and copy from one set of that to another you will be fine

[dan0042]

yes that was what I was saying look in the database and then run that as a single query on your current database.

all have is my phpbb_db_backup On pc , just open that file and look for what ?
or tell me app that will open it ,so can see all names

[IntegraMOD]

You need to open your backup database in wordpad and search in phpbb_users for the user you are looking to add and the copy there info and run it as an sql query like I said a few posts above

[dan0042]

did search for phpbb_usres Not found

[dan0042]

Isthat it ?

[IntegraMOD]

is Kiwi1988 the person that you are trying to add back to your user list?

[IntegraMOD]

did search for phpbb_usres Not found

I am really sorry it was a typo look in phpbb_users

[dan0042]

is Kiwi1988 the person that you are trying to add back to your user list?

yes

[IntegraMOD]

ok post about 5 lines above kiwi1988 and 8 line below and I will pull out what you need to run as an sql

[IntegraMOD]

ok try this
REMOVED

[Drop-Forged]

Ummm, Im not sure her info should be posted in public forums... <img>