I have a database called edureka. I haven't created any tables there. But I have a SQL file which contains all the necessary data for the database. The file is edureka.sql which is in C:\ drive. This file has size of about 103 MB. I am using wamp server.
I have used the following syntax in MySQL console to import the file:
But this didn't work.
If you are using phpMyAdmin, you can simply create a database and then go to the import tab and upload there, or you can SSH to your server and run 'mysql -u username -ppassword database_name < FILE.sql'. Make sure -ppassword has your password after it with no spaces.
From the mysql console:
mysql> use DATABASE_NAME;
mysql> source path/to/edureka.sql;
make sure there is no slash before path if you are referring to a relative path.
Hope it helps!!
You can write following codes to ...READ MORE
I have this script on one free ...READ MORE
I'm attempting to save photos from an ...READ MORE
MySQL is the most popular database ...READ MORE
First you have to go to ...READ MORE
Named route is used to give specific ...READ MORE
This is simple you just need to ...READ MORE
Named routing is another amazing feature of ...READ MORE
mysql -u username -p database_name < ...READ MORE
DECLARE @Names VARCHAR(8000)
SELECT @Names = ...READ MORE
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.