Все вопросы: [mysqldump]

69 вопросов

похожие теги:
0
голосов
4ответов
817 просмотров

Инструмент для копирования базы данных SQL Server 2008 в SQL Server 2008 Express?

У меня типичный сценарий разработки: у меня есть база данных SQL 2008, которую я хочу время от времени копировать в локальный экземпляр 2008 Express, чтобы я мог выполнять разработку, вносить изменения и т. д. в локальную копию. Однако у меня есть некоторые ограничения: исходная база данных явля...

30
голосов
7ответов
62496 просмотров

Резервное копирование представлений с помощью Mysql Dump

Я хочу создать резервную копию только представлений с помощью mysqldump. Возможно ли это? Если да, то как?

1
голосов
3ответов
415 просмотров

Options for maintaining MySQL databases for a django development team

What are some options to avoid the latency of pointing local django development servers to a remote MySQL database? If developers use local MySQL databases to avoid the latency, what are some useful tools to sync schema updates of the remote db with the local db and avoid manually creating, do...

9
голосов
2ответов
3860 просмотров

Library to read a MySQL dump?

I am looking for a library that will allow me to read a mysql dump. I don't want to have to create a MySQL database and import the library and use the MySQL API. I would prefer simply a library that can parse the mysql dump format. I prefer a python library, but other scripting languages are ok...

3
голосов
2ответов
6170 просмотров

How do you update the structure of an entire MySQL database?

ok, say you have two dbs. one you use as a master template which goes through various revisions, let’s say we’re now on revision 3. but the second db is a copy of the template as it was at revision 1. because db 2 is in use, you don’t want to drop any tables, but you do need to update the struct...

7
голосов
5ответов
12001 просмотров

How to write the Mysql binary log position of master when doing a mysqldump from slave?

I am currently running mysqldump on a Mysql slave to backup our database. This has worked fine for backing up our data itself, but what I would like to supplement it with is the binary log position of the master that corresponds with the data generated by the mysqldump. Doing this would allow u...

0
голосов
1ответов
95 просмотров

I need to make new database in mysql with Java

How can I dump database schema to MySQL database with Java JDBC conncetor? I have my database schema in text file.

1
голосов
1ответов
1113 просмотров

How to import DB tables from mysqlhotcopy?

I used mysqlhotcopy to dump a database full of tables. I know have various .frm, .MYD, and .MYI files that I need to import into a different instance of MySQL. Do I just copy these files into a specific folder on the 2nd system, or do I have to run mysqlhotcopy with another command line option ...

0
голосов
1ответов
1225 просмотров

MySQLdump results in lots of commented lines, no real content

I am trying to write a PHP program to automatically created backups of MySQL tables as sql files on the server: $backup = "$path/$tablename.sql"; $table = "mydbname.mytablename"; exec( sprintf( '/usr/bin/mysqldump --host=%s --user=%s --password=%s %s --quick --lock-tables --add-drop-tab...

0
голосов
1ответов
194 просмотров

Error during installing dump

I have the following dump: CREATE TABLE `testdata`.`carer` ( `ID` bigint(20) NOT NULL auto_increment, `IS_DELETED` bit(1) default NULL, `name` varchar(255) default NULL, `account_id` bigint(20) NOT NULL, `patient_carer_id` bigint(20) NOT NULL, PRIMARY KEY (`ID`), KEY `FK5A0E781D4...

5
голосов
4ответов
5117 просмотров

Compress a Mysqldump that is SSH'd to another machine

I have the following: mysqldump -u xxxx -h localhost --password=xxxxx databasename | ssh [email protected] "dd of=httpdocs/backup`date +'%Y-%m-%d-%H-%M-%S'`.sql" ...which SSH's a mysqldump to a remote machine. I need to compress the mysqldump before ...

0
голосов
1ответов
943 просмотров

mysqldump and --tab speed

According to the MySQL Certification Guide, when --tab option is used, a SELECT ... INTO OUTFILE is used to generate a tab delimited file in the specified directory, a file containing SQL (CREATE TABLE) will also be generated and that using --tab to produce tab-delimited dump files is ...

10
голосов
4ответов
5879 просмотров

How do I dump a MySQL database using ant?

I couldn't find any information about how to dump a MySQL database with an ant task. Do I have to create my own task to do this? ANT script ===generate==> myDataBase.sql

6
голосов
4ответов
4695 просмотров

Migrating MySQL to a table with different structure

My company's currently moving our databases around, shifting one set of tables out from the old MySQL instance into the new. We've done some development prior to this migration, and some tables' structure has been altered from the original (eg. columns were dropped). So currently I've dumped th...

-1
голосов
1ответов
3154 просмотров

Foreign key constraints while dumping data

mysqldump --compact --no-create-info -h192.168.150.180 -uroot -p live pnlbus_stops | sed s/pnlbus_stops/bus_stops/g | mysql test I am getting an error: ERROR 1062 (23000) at line 1: Duplicate entry 'AN' for key 1 This is because bus_stops table in the test DB has foreign key constraints. How d...

3
голосов
2ответов
2668 просмотров

Putting the data passed to xargs twice in one line

tmp-file contains: database_1 database_2 database_3 I want to run a command like "mysqldump DATABASE> database.sql && gzip database.sql" for each line in the above file. I've got as far as cat /tmp/database-list | xargs -L 1 mysqldump -u root -p I guess I want to know how to put t...

1
голосов
1ответов
603 просмотров

Backing up MySQL in WampServer

How can I backup my 10MB MySQL database? I don't think WampServer supports mysqldump. I want to migrate it to a web server.

4
голосов
7ответов
5589 просмотров

Best database engine for huge datasets

I do datamining and my work involves loading and unloading +1GB database dump files into MySQL. I am wondering is there any other free database engine that works better than MySQL on huge databases? is PostgreSQL better in terms of performance? I only use basic SQL commands so speed is the only...

38
голосов
5ответов
78853 просмотров

How can I load a mysqldump .sql file to a MySQL database in Windows Vista

I'm trying to move a MySQL database from a Linux machine to one running Windows Vista. Using mysqldump, I've obtained a .sql file, which I have moved to the Windows machine. Whats next? If I were moving to another Linux machine, one could do this sort of thing: mysql -u username -p databasen...

5
голосов
2ответов
8418 просмотров

MySQL "set unique_checks", "set foreign_key_checks" vs. "alter table disable keys"

We're having a problem where a mysqldump script is spending 90% of it's time populating a small handful of the tables it deals with. Eliminating FK's and indexes eliminates the speed problem, but is not an acceptable solution. The dump script does have: /*!40014 SET @[email protected]@UNIQUE...

1
голосов
1ответов
580 просмотров

apache2 and mysqldump causing massive load average spike

I've got a problem that's causing me some headaches and I could use some ideas on how to investigate/fix it. Setup: I'm running a Rails app (Apache2 w/ Passenger) on server A (Rails.A) I'm running the master DB on a dedicated DB server B (DB.B) I'm running a slave DB on server A (DB.A) with st...

1
голосов
1ответов
610 просмотров

restoring mysql db from the contents of split up mysqldump

Hi my database has started to go over 2GB in backed up size, so I'm looking at options for splitting the file and then reassembling it to restore the database. I've got a series of files from doing the following backup shell file: DATE_STRING=`date +%u%a` BACKUP_DIR=/home/myhome/backups /usr...

63
голосов
7ответов
28276 просмотров

How to deal with enormous line lengths created by mysqldump

I'm using mysqldump in a cron job to backup a database with over 2 million rows. It creates a text file which can be used to restore the datalog from the command line. I thought it would be useful to edit the dump before a restore as a quick way of changing values and table or column names - at...

6
голосов
6ответов
4889 просмотров

Backup MySQL database

I have a MySQL Database of about 1.7GB. I usually back it up using mysqldump and this takes about 2 minutes. However, I would like to know the answers to the following questions: Does mysqldump block read and/or write operations to the database? Because in a live scenario, I would not want to b...

3
голосов
3ответов
1766 просмотров

Ensuring data integrity of mysqldump rsync

I use rsync to back up the files on my server, and mysqldump to back up my database. Here's my concern: A mysqldump on my database takes about 30 seconds. I have a table called photos that stores info about the images a user has uploaded, including the path to the file. I am worried about wha...

8
голосов
2ответов
4698 просмотров

generate a "create table" sql command based on an existing table in mysql

I have a mysql shell but for security reasons I cannot run the mysqldump command. I have a table that I made a while ago with a lot of columns, and I want to generate a new "create table" command to create that table on a different database. Is there some command I can run in the mysql shell to...

4
голосов
2ответов
4672 просмотров

Using MySQLdump for sub-set of database migration

I've been using both mysql and mysqldump to teach myself how to get data out of one database, but I consider myself a moderate MySQL newbie, just for the record. What I'd like to do is get a sub-set of one database into a brand new database on a different server, so I need to create both the d...

6
голосов
2ответов
11764 просмотров

Proper format for a mysqldump dynamic filename in a cron?

I have a crontab set up that errors out every time I attempt to do it. It works fine in the shell. It's the format I'm using when I attempt to automatically insert the date into the filename of the database backup. Does anyone know the syntax I need to use to get cron to let me insert the date in...

19
голосов
6ответов
39294 просмотров

Есть ли более быстрый способ загрузить mysqldumps?

Возможный дубликат: Ускорение дампов и импорта mysql mysqldump достаточно быстро, но дамп базы данных среднего размера (20–30 мегабайт) загружается через несколько минут с использованием mysql my_database < my_dump_file.sql Есть ли какие-нибудь настройки mysql, которые я мо...

48
голосов
8ответов
167403 просмотров

Как сделать полную резервную копию базы данных mysql с помощью утилиты командной строки mysqldump

Как я могу сделать полную резервную копию базы данных mysql с помощью mysqldump? Когда я делаю резервную копию, мои таблицы из указанной базы данных только копируются. Процедур и функций нет. Вот используемая мной команда резервного копирования: (Операционная система - Windows Vista.) mys...