New answers tagged

-3

I'm so surprised no one just posted 'mysql -v' as an option. If it gets stuck, the output will stop.


0

You should be able to do the work with CLOUDBASIC RDS AlwaysOn SQL Server Replication product available on the AWS Marketplace: CLOUDBASIC RDS AlwaysOn Replication It supports all SQL Server versions, including Express and Web Edition. The product is designed for Disaster Recovery, data locality and reporting, but can be used for migrations as well.


0

You could try using sed and substitute | (the pipe character - not normally found in data dumps) for the " (double quote) character sed -i 's/"/|/g' My_File.csv sed -i does an inline replace - take a backup before messing with your original file. If you're on Windows - as you appear to be, you can get sed functionality from the answer here or use the ...


-2

You could enable the general log to track what's modified or you could also check the binlogs. With flush logs you can force to create a new binlog. And with mysqlbinlog you can check all modifications. To enable general log: mysql> SET GLOBAL general_log_file = '/mysql/log/all_queries.log'; mysql> SET GLOBAL general_log = 'ON'; mysql> SET GLOBAL ...


1

This issue has been dealt with here. The approach described therein assumes that you have already separated your schema dump by filename. However, if I've understood you correctly, you have a schema dump from which you wish to extract a single file? I have written a small tool which extracts individual table data separately from a schema dump file. It's ...



Top 50 recent answers are included