mysqlimport
Maintain case sensitivity when importing db into windows
I have an export from a MYSQL database on a linux machine however when importing that database into MYSQL on windows all of the table names that were camel cased are now all lower case. The sql dump h[详细]
2022-12-31 21:30 分类:问答Cannot Successfully Export And Then ReImport A View In MySql 5
When I export a database on my development PC, for import on my webhost, it contains the following line:[详细]
2022-12-25 07:49 分类:问答Using mysqlimport where the filename is different from the table name
I\'ve been playing with mysqlimport and I\'ve run into the restriction where the filename has to be the same as the table name.Is t开发者_如何学JAVAhere any way to work round this?[详细]
2022-12-24 17:35 分类:问答How to use mysqlimport to read in result of mysqldump --databases
I have successfully dumped an entire MySQL database using mysqldump --databases generating a nice .txt f开发者_如何学Goile. However, I can\'t see how to read the whole file back into MySQL in one g[详细]
2022-12-21 03:44 分类:问答Importing text to MySQL: strange format
I\'m importing some data from a .txt file into a MySQL database table, using mysqlimport. It seems to import OK (no error messages) but looks very odd when displayed, and can\'t be searched as expecte[详细]
2022-12-18 17:37 分类:问答Can I import tab-separated files into MySQL without creating database tables first?
As the title says: I\'ve got a bunch of tab-separated text files containing data. I know that if I 开发者_如何学Gouse \'CREATE TABLE\' statements to set up all the tables manually, I can then import[详细]
2022-12-18 15:43 分类:问答MySqlImport - Import a date field not in the proper format
I have a csv file that has a date field in a format like (among other fields): 17DEC2009 When I do a mysqlimport, the other fields are imported properly, but this field remains0000-00-00 00:00:00[详细]
2022-12-16 20:23 分类:问答How to refresh a MySQL table without website interruption?
Once a day I need to update an MySQL table with a new file downloaded from the Net using ftp and then mysqlimport. However, I want my website to 开发者_运维问答keep running smoothly during the mysqlim[详细]
2022-12-13 03:36 分类:问答