All Questions
13 questions with no upvoted or accepted answers
2
votes
0
answers
386
views
Faster way to restore MySQL innoDB dump
I have a below MySQL configuration.
# The MySQL server
[mysqld]
....
key_buffer = 384M
max_allowed_packet = 5M
table_open_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = ...
- 49
1
vote
0
answers
518
views
Mariadb large live database dump/restore fails when using recommended options
I have a 58Gb database that is live, using InnoDB engine and I want to dump restore it to a development machine for test purposes. I'm using mariadb 10.4 client and servers on Debian 11 Buster.
I've ...
- 111
1
vote
0
answers
3k
views
how to dump mysql schema without keys and without constraint ? and keep all of them to alter afterwards
i am using ubuntu 16.04 and want to dump large schema with hounded of tables from AWS rds, remove all keys and foreign key , load data and then add back the keys , is there any automatic tool that ...
- 163
1
vote
0
answers
171
views
SQL Error while restoring big database in Mysql
I have successfully created a MYSQL dump on RHEL 6 machine. The dump file is having 40 GB.
When I try to restore it in an UBUNTU machine I got this error.
1
vote
0
answers
2k
views
restore using mysqlbinlog failing
While doing restore from a MySQL binary log file, it is failing with the following error .
mysqlbinlog mysql-bin.000036 | mysql -u root -p asdb
ERROR 1032 (HY000) at line 48: Can't find record in '...
- 173
0
votes
0
answers
516
views
FIX: mysqldump: Couldn't execute '/*!80000 SET SESSION information_schema_stats_expiry=0 */
I've already asked this question in the "Stack overflow" website.
I don't understand why they closed my question even if I didn't get a working solution for my setup.
Why did I submit it?
I'...
0
votes
1
answer
371
views
While restoring from mysqldump file, how do I write the table names to a log file?
Sometimes I've run into situations where developers have changed structures, added/removed columns on different DB servers, environments, etc for the same table and this causes errors such as ERROR ...
- 119
0
votes
1
answer
151
views
MySQL import silently failing
I'm trying to import a large (30GB) SQL file (generated using mysqldump) into an RDS instance MySQL 5.7 database, from an EC2 instance on the same VPC.
It's importing most without a problem, but ...
- 239
0
votes
1
answer
23
views
restore table and populate new data from transaction log
I use mysqldump nightly to backup a database. I'm trying to find a way to do a partial restore on the data from one table. I use the --master-data flag so I know where in the transactions log my data ...
- 149
0
votes
0
answers
379
views
error while restoring database from mysql: ERROR 1006 (HY000)
I made a mysqldump from all my databases prior to fully deinstall and reinstall MariaDB. while restoring the databases with the following command, logged in as root:
MySQL -u root -p < /mnt/...
0
votes
0
answers
136
views
How to speed up MySQLl loading from dump file?
I'm using mysqld Ver 5.7.25-0 in Ubuntu 16.04. I dumped from AWS Relational Database Service (RDS) with mysqldump --single-transaction --quick --max_allowed_packet 1G ... and now when I tried to load ...
- 163
0
votes
1
answer
46
views
mysqldump - does it have non-repeatable DMLs?
We are migrating databases using mysqldump, and since this is the first time I'm doing it, I have a couple of questions.
If in the middle of mysqldump the utility crashes(for some reason- latest was ...
- 11
0
votes
1
answer
86
views
I'm building up a large MyISAM table from a few dumps. The first 21GB took less than 10 hrs total. The next 5GB is forecasted to take two months
I had a couple machines building up identical MyISAM tables. I've dumped all of those tables to a few files, and am now trying to restore them all into a single table on my own machine.
The first ...
- 215