All generations.
function makeBackup($dbName, $dbUser, $dbPass, $dir) {
$sql = "mysqldump --host=localhost --user={$dbUser} --password={$dbPass} --databases $dbName > {$dir}/$dbName.sql";
return exec($sql);
}
makeBackup('name', 'user', 'password', '/destination/path');
function backup_db( $db_name, $backup_name ) {
$backup_file = fopen( $backup_name, 'w' );
$result = mysql_query( 'SELECT * FROM ' . $db_name );
while ( $row = mysql_fetch_assoc( $result ) ) {
fputcsv( $backup_file, $row );
}
fclose( $backup_file );
}
function MVC($db, $user, $pass){
//crear la base de datos
$sql = "create database $db";
//crear un backup de la base de datos en un archivo
$sql = "mysqldump -u $user -p$pass $db > $db.sql";
//restaura el backup de la base de datos
$sql = "mysql -u $user -p$pass $db < $db.sql";
//borra la base de datos
$sql = "drop database $db";
}
// database.php
<?php
return [
'database' => [
'host' => '127.0.0.1',
'user' => 'root',
'password' => '',
'database' => 'blog'
]
];
function backup_db($database, $user, $password, $host='localhost', $port=3306, $backup_path='/tmp'){
$file = $backup_path.'/'.$database.date('d-m-Y').'.sql';
$cmd = "mysqldump -h{$host} -P{$port} -u{$user} -p{$password} {$database} > {$file}";
exec($cmd);
return $file;
}
backup_db('db01', 'root', '123', '10.0.0.1', '3306', '/tmp');
function backup($database, $user, $password, $table)
exec("mysqldump --user="$user" --password="$password" "$database" "$table" > "$table".sql");
function backup() {
echo "
#!/bin/bash
/usr/bin/mysqldump -u username -p database_name > /home/user/backup/database_name_$(date +%Y%m%d).sql
"
}
Generate
More than just a code generator. A tool that helps you with a wide range of tasks. All in one place.
Function from Description
Text Description to SQL Command
Translate Languages
Generate HTML from Description
Code to Explanation
Fix invalid Code
Get Test for Code
Class from Description
Regex from Description
Regex to Explanation
Git Command from Description
Linux Command
Function from Docstring
Add typing to code
Get Language from Code
Time complexity
CSS from Description
Meta Tags from Description
