473,486 Members | 2,127 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Timestamp problems when importing mysqldump data

Greetings

for a while I simply can not import properly timestamp data back to
database. I dump all databases with mysqldump --opt --all-databases >
backup.sql and backup file is correctly created. All my tables have
timestamp column since VB programs and MyODBC do not work properly
without it. When I import data back, every timestamp column is
restored to 0000-00-00 00:00:00. That is incorrect data and time
format and my application fails since MyODBC doesn't work properly. I
need to find a way to back up full database structure but dump every
field except timestamp fields or I must find a way to restore old
timestamp values. Anything but 0000-00-00 00:00:00.

Thank you all,
Bruno
Jul 23 '05 #1
0 1426

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

8
17479
by: Irvin Amoraal | last post by:
I am trying to create a CSV using mysqldump that will be viewed in MS Excel, and have a formatting question. From the command line I type: > mysqldump "--where=ent_date > \"2003-07-01\""...
0
2553
by: Blah Blah | last post by:
i just thought i'd shoot out a quick email on problems i've been having with utf-8 in moving from 4.1.0 to 4.1.1. (please note that because i am using UTF-8 as my default character set, i compiled...
5
3172
by: Ville Rontti | last post by:
Hi I have two separate databases (A and B). Both databases have one table (A). How I could transfer the contents of table A from Database A to database B table A? The tables are same. Ville
7
7395
by: Adam Smith | last post by:
Hope this is the right news group!! I did a server upgrade and at the same time did a mysql update from 4.0.12 to Ver 12.22 Distrib 4.0.16 mach1# mysql --version mysql Ver 12.22 Distrib...
1
3052
by: steve | last post by:
Hi, I have a 80 meg dump file created with mysqldump. I need to import it into a mysql db on Windows. On linux, I say "shell>mysql dbname < dumpfilename" But that does not work on Windows. ...
2
2281
by: Jean Bidule | last post by:
Hi, I installed phpmyadmin to test my site on my homecomputer. The table i want to "upload" in my mysql table is about 5 Mb but in phpMyadmin the maximum size is 2048 kb. Where can I change...
2
3477
by: madeleine | last post by:
I'm hoping the answer to this is that I'm just doing something silly, but I'm really scratching my head over this one. I'm importing data from multiple workbooks, each workbook has a sheet called...
1
4789
by: Claire | last post by:
Hi, I'm trying to run mysqldump.exe from my c# application, running on windows vista with visual studio 2005. The following code does not produce the output file. The same line used in a command...
2
12125
by: Alien | last post by:
I just managed to use mysqldump to dump a database into a text file. Now I uploaded it into my server where i want to import it. I tried looking up in google and came up with this command: ...
0
7100
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6964
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7175
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6842
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
4559
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3070
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3070
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1378
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
0
262
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.