[mysqldump] Forum Topics

How to downgrade mysqldump tools: I am using mysql bench and when trying to export online databases from mysql bench to sql file I am getting this error: mysqldump.exe is version 8.0.13 but the MySQL Server to be dumped has version 5.7.21. Because the version of mysqldump is not the …

Hi all! I have a big problem that I would like some help. I use Mysql Workbenc 5.2CE. I changed the default port to 3301. The mysql server is up and running well (I access it from an app I'm making with VB.NET). The problem is I can't get mysqldump …

I am not able to restore sql file from linux command prompt. I have used the below command. Here is the message.No table is restored. I am running this in my local machine adminuser@virtualboximagescom-VirtualBox-34s7dkv4:/$ mysqldump -u root -p replication_test </home/adminuser/Downloads/rp.sql Enter password: -- MySQL dump 10.13 Distrib 5.5.28, for debian-linux-gnu …

I have a very simple wish, to dump all databases so I can lock up a backup of the databases, tables, users and so on. It looked like [CODE]mysqldump -v --all-databases -u root -p secret > "${directory2}""$h"_mysql_dumpall.sql[/CODE] worked, however the file contained a little error message telling me I had …

I was trying to backup a database with the name test. I got the error as below: ERROR 1064 (42000): You have an error in your SQL syntax; check...... This error occurred when I am executing (command line) mysql> mysqldump -u root -p password test > test.sql; How could this …

Hi, I have two databases (live and staging). Extra columns have been added to various tables within the staging database by another developer while they were extending the websites functionality. Now has come the time to put the new functionality live, which means taking the staging database schema, creating a …