Linked Questions

I want to keep a backup of all my MySQL databases. I have more than 100 MySQL databases. I want to export all of them at the same time and again import all of them into my MySQL server at once. How ...

I need a variable to hold results retrieved from the database. So far this is basically what I'm trying with no success. myvariable=$(mysql database -u $user -p $password | SELECT A, B, C FROM ...

I tried many scripts for database backup but I couldn't make it. I want to backup my database every hour. I added files to "/etc/cron.hourly/" folder, changed its chmod to 755, but it didn't run. At ...

I used this script for years on my VPS. And it's still working. DBLIST=`mysql -uroot -pROOT_PASSWORD -ANe"SELECT GROUP_CONCAT(schema_name) FROM information_schema.schemata WHERE schema_name NOT IN ('...

MySQL is installed on my laptop and it works fine, except that I am allowed to log in without supplying the root password. I can also log in by supplying the root password. If the supplied password ...

I have upgraded to mysql 5.6.13 and thought I would try the new --login-path feature. I configure with "mysql_config_editor set --login-path=local --host=localhost --user=user --password" After ...

For example, say if I have a script saying: #!/bin/bash sudo setpci -s 00:02.0 F4.B=00 How do I put the root password into the script so that it accepts it as the password when it reads and executes ...

I have password stored in a variable $db_pwd and I want to pass it to mysql_config_editor in a shell script. I can not use config file or db_pwd environment variable. I am doing this ...

Hi I have a script to partition some mysql databases. We are upgrading from 5.5 to 5.6. While testing the scripts i noticed that with the new 5.6 version mysql returns Warning: Using a password on the ...

I've created a cronjob using cPanel. Every a certain period of time it runs this php file that generates a backup: <?php include $_SERVER['DOCUMENT_ROOT'].'conectar.php'; $filename='...

I have a number of large BASH scripts which execute queries against a MySQL database. When running these scripts on MYSQL version 5.7.17, I get the following error' [Warning] Using a password on the ...

I am trying to connect to a remote MySQL Server from a Jenkins job. I bound the MySQL user credentials into two variables MYSQL_USERNAME and MYSQL_PASSWORD. I need to SSH first, and then connect to ...

I am trying to export a mysql schema from remote server to local but geting the following error: C:\Program Files\MySQL\MySQL Server 5.6\bin>mysqldump --skip-secure-auth -h x.y.z.d -uatulya -p'...

Am trying to get a auto backup of our mysql database via a cron job that runs daily. We have: $database_user = 'VALUE'; $database_pass = 'VALUE'; $database_server = 'localhost'; // Name of the ...

I know there're tons similar question but somehow I can't get it right. When run this command, my "dump.sql" produced desired result mysqldump -uuser -ppassword --comments --single-...