Importing large MySQL Databases with BigDump

I have recently had a lot of people requesting information on how to export and import large MySQL databases. This video will walk you through the steps to get this done.

[marciajoscelyne]

I'll just like to say - Thank you so much for this! Really saved me! Really appreciated.

[Ilovehomoeopathy]

An awesome tutorial. Saved me time and $$$.

[bikinisunrise]

For extremely large databases you would be best splitting them up unless you are running a lot of memory assigned.phpmyadmin is good but if you are running very large databases(2GB+) you would be best using cli.I manage many 10+GB SQL files so I know the hassle.

[sampeters]

I keep getting the error message: Error at the line 389: ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Api Sessions'; (I'm trying to import the sample data from the latest Magento Community edition into my phpMyAdmin.) Any idea what I can do?

[lvekua]

did you have to create virtual host and directory sql-tutorial initially and then but big dump along with sql file???

[TrenC]

I get an error message during the import, "UNEXPECTED: Can't set file point behind the end of file", im assuming this is because my database is too big, how do i work around this?

[BlueNetUSA]

after uploading to server, what address can be use to start Bigdump upload?

[golfkicksyou]

Why is it that I don't get that screen to Import from am I doing wrong

[Ramthapaliya]

you don't need big dump after this is only to remove dump file of your database

[Ramthapaliya]

how about joomla 3 version of database?

[lvekua]

I get following error, any idea what could it be? Thanks.
ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT=Api Sessions