New answers tagged mysqldump
1
Some information can be found in SET Syntax and this bug
The SET statement assigns values to different types of variables that affect the operation of the server or your client. Older versions of MySQL employed SET OPTION, but this syntax is deprecated in favor of SET without OPTION.
How to fix:
if the problem happen when you are creating the ...
-2
Add space in between -uroot to -u root and no gap in password -p dba to -pdba
mysqldump -u %mysqluser% -p%mysqlpassword%
-2
From where you are running this code?
mysqldump -uroot -p dba admin > D:\admin.sql
You don't have space between your -u and root. this should be be like these:
mysqldump -u root -p dba admin > D:\admin.sql
assumming that your username is root and password is dba
0
It's possible to configure database replication (master/slave) and then create backup on slave server at any time.
0
Given that the valid characters for unquoted identifier characters are documented here, you should be able to find non-confirming table names in information_schema using a regular expression match, with this query:
SELECT *
FROM information_schema.tables
WHERE table_name NOT RLIKE '^[0-9a-zA-Z$_]+$';
0
But the link also recommends XtraBackup from Percona, which is faster, no locks on tables that are already in use and gains no time for restoration. For 500GB of data I prefer Percona XtraBackup to be quick and efficient unless you want to convert them to innodb_file_per_table model if it wasn't from the existing DB server. Below link explains on how to ...
1
Sure enough, --single-transaction is supported from the MySQL command line.
mysqldump --single-transaction databasename
Will use all of the default options from --opt (except for --lock-tables, which is overridden by --single-transaction) as well as --single-transaction.
That really should be all there is to it.
I recommend briefly reading through all ...
6
It's not difficult. Just need a set section in your LOAD DATA INFILE command.
mysql> create table tst ( datecol datetime );
Query OK, 0 rows affected (0.04 sec)
mysql>
File:
[root@node1 ~]# cat /tmp/tst.dat
01-JAN-03
21-MAR-09
28-FEB-11
[root@node1 ~]#
Test:
mysql> load data infile '/tmp/tst.dat'
-> into table tst
-> fields ...
0
You can try some GUI clients like SQLyog. Where you can select the tables which you want to dump.
0
Long story short: You do not have the user 'lumicrm'@'%' on the DB Server.
Login to MySQL and run
SELECT user,host FROM mysql.user WHERE user='lumicrm';
Let's say you see the user 'lumicrm'@'localhost'
You have to create the user so that the view can be recognized. There are three(3) things you can try
Try This #1
Login to MySQL as lumicrm and run ...
1
OBSERVATION #1
It is not recognized because of a typo
You have
if [ "${database}" == "information_schema" ] || [ "${database}" == "performance_schema" ]; then
additional_mysqldump_params1="--single-transaction"
else
additional_mysqldump_params=""
fi
It should be
if [ "${database}" == "information_schema" ] || [ "${database}" == ...
1
mysqldump: Got error: 1017: Can't find file: 'drupal_install_test' (errno: 2) when using LOCK TABLES
You apparently have a missing drupal_install_test in your database schema. As the name says, it's a test table that is created at installation time to test the performance of the database and of the database user you provided for your site. At the end of the installation process, it gets dropped from the database.
The problem here is that the table has been ...
Top 50 recent answers are included
