Creating Sql File From Sql Query

Question

I have a huge amount of data in MariaDB. I need to do create dump files from queries. So far I got something like this.

SELECT DISTINCT uretici INTO OUTFILE '/home/admin/web/example.com/public_html/public/manufacturers.sql' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\n' FROM data;

This gives me a SQL file which is cant be imported. I need an importable SQL file. What to do about it?

Does this answer your question? How to export and import a .sql file from command line with options? — nbk
– nbk, Commented Jul 10, 2021 at 23:18

Samuel Silas · Accepted Answer · 2021-07-10 22:42:06Z

3

You can use the following command

mysqldump -u [database_user] -p [database_name] | gzip > [filename_to_compress.sql.gz]

answered Jul 10, 2021 at 22:42

Samuel Silas

3392 gold badges4 silver badges13 bronze badges

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

2 Comments

Samuel Silas Over a year ago

If you need any clarifications please let me know

Kıvanç.A Over a year ago

Thank you for your answer samuel. I solve this problem while ago with the following command. ``` mysqldump -u root -pxxx admin_tecalliance data -w "oem_no IS NOT NULL " > file.sql;" ```

Collectives™ on Stack Overflow

Creating Sql File From Sql Query

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related