|
|
Browse by Tags
- 1044
- 1045
- access
- auto_increment
- backup
- bash
- binary
- blob
- breaks
- clause
- connect
- data
- database
- dump
- error
- got
- indexes
- insert
- limit
- line
- max_allowed_packets
- mysql
- mysqlimport
- not working
- only
- opposite
- problem
- restore
- schema
- script
- structure
- table
- version
- where
- without
-
Problem with mysqldump and restoring large table with BLOB column that stores images
I'm currently trying to restore a MySQL database that has a table called product_images, which as you might have guessed, has a BLOB column for storing GIF/JPEG images. The table stores approximately 12,000 images, the physical size of the table is about 208MB. The problem I have when restoring the... -
Dumping binary data with mysqldump
I have binary data stored in a Blob field, how can I use mysqldump to create restorable "backup files"? -
mysqldump not writing data to target database
I'm using MySQL dump 10.13 Distrib 5.1.37, for Win32 (ia32) to transfer data to a host, however it is not working. No data is written, I just get a generic message, claiming the dump was successful, when in fact it was not. I can take exactly the same dump code, insert it into myphpmyadmin, for example... -
mysqldump longtext - longblob
I need to backup my datas in my table. There is longtext field with a huge data in it. I used mysqldump command to backup my table, it didn't give me correct result. I have 1000 records approx., but i got only 3 of them insert value. Is there any parameter for it. I heard about max_allowed_packets... -
Mysqldump omits/ignores auto_increment?
I ran a mysqldump in order to backup my db - but when I imported it I noticed that the auto_increment option was not executed. Any ideas/solution for this? -
mysqldump Only Some Records Because Database is So Large
I am setting up a development system and need some critical tables, many of them which only contain 100 or less rows. Some of the tables contain GB of info that I don't wan to copy over. I have done mysqldump to get just the schema, is there any way to limit the table data dump to let's say 1000... -
mysqldump INSERT rows in each line
Hello, I've noticed that since I have installed "MySQL Distrib 4.1.10" mysqldump is now creating more/all inserts in one "INSERT ROW" like: INSERT INTO `table` VALUES (1,'something'),(2,'anything'),(3,'everything'); The earlier version did it in this way... -
Bash Script To Connect to MySQL
I am a newbie to Linux shell scripting and I am hoping somebody can help point me in the write direction. I want to create a basic Bash Shell Script that will allow me to connect to MySQL. Once connected I will do various operations (IE. mysqldump) Also, if you can add something about cron and how to... -
mysqldump error 1045
Hi, I am running Windows Server 2003 and MySQL 5.0.22. I want to back up my database every day, so I searhed the web and found examples on how to do this and have made a batch file I can schedule to run: @ECHO OFF for /f "tokens=1-4 delims=/ " %%a in ('date/t') do ( set dw=%%a set mm... -
mysql DUMP without/of indexes
How can i take mysqldump without indexes ? and also is there any way to only dump out the indexes ?