Need help with BigDump

[Tumling]

I am trying to use Bigdump to restore my database that is 11mb, but i keep getting this Error:
[code]Error at the line 1774]

And i dont know what to do....

Im sorry but i dont know how to talk SQL language, so i will sound like a noob but hey i am

[Fubie]

I no longer use bigdump, I now use phpmysql which is installed on the host.

But if I remember correctly when I was using bigdump I had to remove every instance of MyISAM.

Make another copy of your db on your hd. then open it and do a search and replace all. search for MyISAM and leave the replace field blank.

Make sure you do this with a 2nd copy of your db.

[Tumling]

I might ask stupid now, but if you are useing phphmysql how do you install a backup that is bigger then 20,480KB ?

on my phpmysql it says that txt file may be Max: 20,480KB....

That is why i started to use Bigdump so it could load my db file in smaller pieces, is there a better way to do it with phpmysql ?

[Fubie]

you are thinking of phpmyadmin. phpmysql is an app I installed. You can get it in my geek forum's download section.

[Tumling]

oh yeah sure sorry <img>

[Bush]

You can use MySQL Administrator, which is an application from the developers of MySQL to dump/restore databases remotely. Its a small application and I moved my site using this method - Worked great. I'll post a link when I get home!

[Tumling]

ok, great <img>

[Bush]

Tumling,

You can get MySQL Administrator [url=http]here[/url].

Documentation is [url=http]here[/url].

If you need futher help dumping your database, please PM me.

Thanks.

[Tumling]

i will get back to you, im just gona try myself first <img>

[Bush]

OK. Its not that hard to use, and really you should DUMP the database with this, and RESTORE the database with this. I feel very save with this application, seeing how it comes from the MySQL developers and isn't a 3rd party application for database management.

[Tumling]

I no longer use bigdump, I now use phpmysql which is installed on the host.

But if I remember correctly when I was using bigdump I had to remove every instance of MyISAM.

Make another copy of your db on your hd. then open it and do a search and replace all. search for MyISAM and leave the replace field blank.

Make sure you do this with a 2nd copy of your db.

I dont have any MyISAM in my DB file.
And my host dont allow the use of other programs then phpmyadmin...

[Tumling]

I just removed the phpbb_force_read_users from the db file when i used Bigdump and then i copy/pasted the phpbb_force_read_users from the old database to the new database and it worked i think, i didnt get any errors that is <img>

[Fubie]

phpmysql is installed like a forum. It does not need to be installed at the Admin level.

It can only access your sql db's.

[Michaelo]

READ maybe a restricted word in MySql use the following code. Works for me!

Code: Select all

 CREATE TABLE phpbb_force_read_users(user varchar(255) NOT NULL ,`read`int(1) NOT NULL ,time int(10) NOT NULL);  

Mike

[ayasha]

i am full of questions today <img>

i installed mysqldumper on my server, now i don't understand the part of the install instructions that talks about perl script, is this something i have to do for it to work properly?

[Fubie]

The perl script is used for auto backup using cron.

So you only need it for doing automated backups.

[ayasha]

thanks Fubie, but i never trust auto back ups, rather do it myself <img>

[Michaelo]

I trust them completely provided I'm looking at them when they are working <img>

[ayasha]

my point exactly Mike, anything done automatically, i tend to walk away from the computer for a sec.....

next thing i know, there is 3 or 5 teenagers on here, downloading music and videos, telling me they did not close out my stuff, but they usually do

[found it]

my point exactly Mike, anything done automatically, i tend to walk away from the computer for a sec.....

next thing i know, there is 3 or 5 teenagers on here, downloading music and videos, telling me they did not close out my stuff, but they usually do

Lmao very funny....

[dan0042]

getting this Error:
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

[dan0042]

getting this Error:
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

Hello,

it's an mySQL error. It means your dump file is not 100% compatible with the target database. It can happen when the destination database is newer/older than the source database.

Alexey