CRUD MySQL and MySQL dump to SQL file #mysql
Edit
by Jose Miguel - 10 years ago (2014-10-28)
I need a class for connect to MySQL and dump SQL file
| Create insert statement, update, select and delete statments |
Ask clarification
2 Recommendations
This class can dump a MySQL database records to a SQL file.
It can get the list of tables of a given MySQL database and retrieve the data of the records of those tables.
The class can generate a file with SQL statements to insert the data back into the database tables.
| by Bharat Parmar package author 455 - 8 years ago (2016-04-11) Comment
This class can dump a MySQL database records to a SQL file.
It can get the list of tables of a given MySQL database and retrieve the data of the records of those tables.
The class can generate a file with SQL statements to insert the data back into the database tables. |
- 1 Comment
1.
by bisma - 5 years ago (2020-01-27) Reply
z
mysql_dump: Backup and restore MySQL databases from SQL files
This class can be used to take backups of MySQL databases by generating files with SQL commands similar to the output of mysql_dump program.
It can also restore a database from SQL commands generated by the backup process.
The class can generate the backup output of one or more databases. It may also backup all tables of a database or just a few tables.
The output may be stored in a file or served for download. It may have line breaks characters compliant with either Unix/Linux, Windows or Mac OS.
| by Manuel Lemos 26695 - 10 years ago (2014-10-28) Comment
If you just want to create a backup file if a MySQL database using SQL statements, this class offers a certain flexibility because it can create MySQL dumps of multiple databases, or let you choose just a set of database tables. |