MyBB Community Forums

Hello,

I am getting this error when trying to import a large (200mb+) .sql file into my mybb database (localhost):


Line 293 from sql.php reads:

$tmp_sql .= substr($buffer, $start_pos, $length_to_grab);

I've been sat here tearing my hair out for the best part of 4 hours working on this, to no avail.

Any help would be appreciated!

Thanks,
HybridForum

edit: Please move if in the wrong forum

It explains what's the problem. You're out of memory.

Quote:Allowed memory size of ### bytes exhausted [...]

You're doing it in php my admin, not MyBB, so it's not directly supported by the MyBB team. As others have pointed out, though, it has to do with the memory allocated to PHP.

(2012-09-04, 09:06 PM)AiedailEclipsed Wrote: [ -> ]It explains what's the problem. You're out of memory.

Quote:Allowed memory size of ### bytes exhausted [...]

I don't think this is it, because as you can see I have set "max_memory" to a value higher than the memory needed...

@Personabove: I couldn't think of where else to put this!

Use MySQL Dumper. It's perfect for importing larger databases.

http://www.mysqldumper.net/

(2012-09-05, 09:37 AM)Nathan Malcolm Wrote: [ -> ]Use MySQL Dumper. It's perfect for importing larger databases.

http://www.mysqldumper.net/

Isn't that program for backing up? So for exporting rather than importing?

It can be used for either/both. I've used it in the past and it works great.

just use mysql directly from the command line

mysql -u username -p password database_name < filename.sql

(2012-09-06, 08:25 PM)Nathan Malcolm Wrote: [ -> ]It can be used for either/both. I've used it in the past and it works great.

I couldn't work out quite how to get it to import, everything I made it do gave me a 30 second time out error...

I will try the direct SQL method.

edit: It doesn't seem to do much, it just adds a new command line and pauses really...

Try bigdump instead. I've used it a few times when working with large databases: http://www.ozerov.de/bigdump/