Import Large SQL File to Live Domain using BigDump

Technologies used:
- phpMyadmin (Database Manager)
- BigDump (Large SQL Importer)
- CPanel (Website Control Panel)
- WinSCP (FTP Client)
- Sublim Text (Text Editor)

Summary:
- Create a database.
- Create a database user and password.
- Assign the database user to the database.
- Obtain database credentials such as database name, database username, database password.
- Input the database credentials.
- Input the filename of your sql file.
- Connect to your website server using an FTP Client. Input your FTP login credentials to connect to your FTP server. You can obtain your FTP credentials in the control panel.
- Get inside your website's public folder.
- Create a new folder and name it 'bigdump'.
- Click "Start Import"
- The status of the importing of file will be displayed.
- Check the database of your website if the importing was successful.
- Delete the bigdump folder/directory in your website.

If you have any questions or clarifications regarding this tutorial, you can comment it below.

I'll respond to your emails or comments as soon as I can. Don't worry ;)

If you have other ways to do this, I would greatly appreciate it if you comment it below.

Don't forget to like this video and subscribe to my channel.
Thank you so much for watching and enjoy the rest of your day.

[flamedicedesign]

I don't usually leave thank you comments, but when I do I leave thank you comments to helpful videos. Thank You.

[richardgenck]

You explained that SO WELL!! Very simple and easy to understand, I wish I had instructors like you when I was first learning about FTP and databases.

[bytes]

I was searching for on how to do this, but I'm failed after reading a lot of tutorials until I watch this video! Thanks a bunch!

[jobsadamsutube]

Thanks a lot - this video is very helpful.

[LetsBuildDestinyu]

Thank You so much for this tutorial. It helped me a lot Superb.

[banuchandar]

At this place the current query includes more than 300 dump lines error occured change define ('MAX_QUERY_LINES', 300); and replace 300 with anything you want in bigdump.php

[IvanCazorla]

Hi there, I'm getting this error that I don't know how to fix:

BigDump: Staggered MySQL Dump Importer v0.36b
Processing file: camping2.sql

Starting from line: 1

Error at the line 38: ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Query: --
--
--
--
CREATE TABLE `ps_access` (
`id_profile` int(10) UNSIGNED NOT NULL,
`id_tab` int(10) UNSIGNED NOT NULL,
`view` int(11) NOT NULL,
`add` int(11) NOT NULL,
`edit` int(11) NOT NULL,
`delete` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8

MySQL: Table 'ps_access' already exists

Any ideas?

[vidb]

it did not work for me. Gave error - PHP Warning: Unknown: failed to open stream: No such file or directory in Unknown on line 0
PHP Fatal error: Unknown: Failed opening required (include_path='.:/usr/l

[jamesorriola]

do i need to change urls or links on the database?

[samuvelparthiban.j]

replace hostname "localhost"