Import from SQL file - feature request

[blessedjasonmwanza]

Information

• Version of Medoo: 2.1.2
• Type of Database (MySQL, MSSQL, SQLite...):
• System (Liunx\Windows\Mac):

Description

This is a feature request; When you have time, may you kindly add the ability for us to import an SQL file directly into a database?

Detail Code example

$file_location = 'dir/file.sql';
$db_instance->import_sql($file_location);
//or
$db_instance->import_raw($file_location);

Response

Can return true, false or add the error message into the $db->error var

[catfan]

With the experience of importing the database file, the better way to do this is to use the SQL command line or other database management tools to ensure the correct result.

[blessedjasonmwanza]

Hey @catfan 🤓 ... I was thinking about this and experimented with something that works.

//First, we load the db file into a variable
$db_sql_file = file_get_contents("db_file.sql");
//then we run query on it to perform whatever instructions are in the SQL file against the database instance we're connected to😄 
$db_instance->query($db_sql_file);

Is this something that can be improved on? You may share your opinion or ideas whenever time allows.

HappyCoding 👨🏽‍💻

[catfan]

@blessedjasonmwanza Yes, it can simply work in some cases. However, the result is not guaranteed if with a different setting, database version, platform, or others.

[blessedjasonmwanza]

@blessedjasonmwanza Yes, it can simply work in some cases. However, the result is not guaranteed if with a different setting, database version, platform, or others.

Oh - I see, 🤔 ... Makes a lot of sense 🤓 . Thank you.