import mysql data dump to Maria DB

Question

I am trying to import mysql data dump to Maria DB with below command

mysql -u root -p --one-database new_db < data_dump.sql;

But I am getting below error

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysql -u root -p --one-database zapcheck < zapcheck.sql' at line 1

I tried different combinations but nothing worked. Its not even telling what's the issue.

Please let me know the issue here or is there any other way I can import?

mysql is a shell command, you don't use it inside the mysql program. — Barmar
– Barmar, Commented Sep 23, 2021 at 4:01
@Barmar ahh I see.. now its showing the error if I run outside maria db. Where I am supposed to keep the dump file? Its not able to access it — IamGrooot
– IamGrooot, Commented Sep 23, 2021 at 4:10
@Barmar getting this error The system cannot find the file specified.. When I run mysql -u root -p --one-database new_db < data_dump.sql; — IamGrooot
– IamGrooot, Commented Sep 23, 2021 at 4:17

Lijesh Shakya · Accepted Answer · 2021-09-23 06:28:30Z

9

You can try the command below to import the file:

Note: Open the terminal where dump.sql is located

After opening the terminal:

//Skip this process if you have already created a database.
Mysql> create database newdb;

// Using the new created database
Mysql> use newdb;

// Importing the dump.sql file to newdb database
Mysql> source dump.sql

edited Sep 23, 2021 at 6:28

Lijesh Shakya

2,5462 gold badges22 silver badges47 bronze badges

answered Sep 23, 2021 at 4:05

yard

1243 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Barmar Over a year ago

What is zapcheck?

Barmar Over a year ago

Did you read the error message? The problem is that he's trying to run the command as a SQL query.

IamGrooot Over a year ago

Getting this error while running second command -> ERROR: Failed to open file 'zapcheck.sql', error: 2. File path is not proper I guess. Where I am supposed to keep the dump?

IamGrooot Over a year ago

Now it worked after directing to correct path. Thanks

Collectives™ on Stack Overflow

import mysql data dump to Maria DB

1 Answer 1

4 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Related