81685/how-to-import-sql-file-into-mysql
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:
mysql>c:/edureka.sql;
But this didn't work.
Hello,
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.
Hello @kartik,
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!! Thank You!
Hello @kartik, You can write following codes to ...READ MORE
Hello kartik, MySQL is the most popular database ...READ MORE
Hello kartik, Actually there are many functions that ...READ MORE
PHP is compiled to byte code before ...READ MORE
Hey @kartik, First you have to go to ...READ MORE
Named route is used to give specific ...READ MORE
Hello, This is simple you just need to ...READ MORE
Hey @kartik, Named routing is another amazing feature of ...READ MORE
Hello @kartik, Try: mysql -u username -p database_name < ...READ MORE
Hello @kartik, Use COALESCE: DECLARE @Names VARCHAR(8000) SELECT @Names = ...READ MORE
OR
At least 1 upper-case and 1 lower-case letter
Minimum 8 characters and Maximum 50 characters
Already have an account? Sign in.