Software :: MySQLdump Reported Completed But Wrong Time Shown
Jan 14, 2010
I just backup my mysql db using mysqldump. I run it around 6pm of the evening but I just notice that on the last part of the dump file, it says "Dump completed on 2010-01-14 11:30:01". The time is "Jan 14 19:30" when I run mysqldump. Though the content is corrent, I still want to know why the dump reported it was completed but wrong time. I don't have my.cnf on my /etc so it means all was default by mysql. If I'm not mistaken, timezone by default in mysql is gmt.
My /etc/sysconfig/clock is
ZONE="Asia/Manila"
UTC=true
ARC=false
When I do "select now();" on mysql shell, it was the same with my system. I want to prove my backup was right but this thing confuse me a bit.
I am having difficulty with my brother hl-2040 printer. Linux recognizes the printer and it's set as the default. The job shows up in the printer queue as completed, but nothing comes out of the printer.
I am an openSuSE user for many years. My current installation is openSuSE 11.2. However, my first was SuSE 6.4 and I have been _constantly_ upgrading since then until reaching the current openSuSE 11.2. The technical issue I have been facing lately is with the kernel version of my current system: although it should be 2.6.31.5-0.1-desktop, as this is the one I have chosen via the online update mechanism and the yast2 system boot-loader procedure, grub shows it as preselected, the boot procedure in the end greets me mentioning this very kernel version, _but_ when I issue the command: uname -a in a command prompt, I am informed of using linux kernel version: 2.6.18.2-34-default #1 SMP PREEMPT
I am really quite puzzled, since I _cannot_ find any such vmlinuz file under /boot/ ! Could it be that my system properly runs with the expected kernel version, but uname mistakes it with a different one? Is there a way to determine the actual version of the linux kernel that my system currently runs with? If it's a problem with uname, have you got any suggestions that could potentially shed some light towards the origin/cause of the reported issue?
I installed Ubuntu inside windows(Win 7).Both works good.I found that system time is wrong in both OS.Every time i Change it manually but it changes again on reboot!
After installing the 11.3 CD download, I find that there is no time display in the right hand part of the panel although there is a large blank part of the display apparently waiting for it.Has anyone encountered this? My settings for time are fine but after resetting time, and before resetting time, the actual time display does not appear.
I am having the problem enabling Bluetooth on my Dell studio 1555. When I start System->Preference-Bluetooth Manager, I get message Connection to Bluez failed : Bluez daemon is not running, blueman-manager cannot continue.
Some information : uname -a Linux T-D 2.6.32-22-generic #33-Ubuntu SMP Wed Apr 28 13:28:05 UTC 2010 x86_64 GNU/Linux"
hcitool dev Devices: hci0 00:22:5F:97:20:A0" dmesg | grep 'Bluetooth' .....
rfkill list 0: hci0: Bluetooth Soft blocked: no Hard blocked: no 1: phy0: Wireless LAN Soft blocked: no Hard blocked: no
I have reinstalled, removed rebooted and installed bluez, bluez-utils, Blueman, bluetooth number of times now. Two attachments are included, BlueZ output screen Bluetooth output screen Bluetooth works perfect, when I boot lucid using live CD, So I guess there is some problem with the installation. I upgraded from 9.10 to 10.4. It never worked with 9.10 and its continuing the same way.
After a restart, I see bluetooth icon, but its grey all the time. Two more screen shots.. Bluetooth output screen (Turn on) Bluetooth output screen (Turned on) sudo /etc/init.d/bluetooth status * bluetooth is running
Not able to remove one of the time shown in taskbar,it can't be editable and I'm not able to remove it from my panel,when it appeared the shutdown button was removed by itself.No Idea how it happens, please tell me why it happened and how to change it.
I wonder if its any easy way to configure grub2...I dont want to change fonts, background or anything special. Just to change default operating system time to shown menu etc.
Is there anythink like known from KDE? graphical tool to tick what I wont, choose time from list or type it in, click OK to finish and job done... without any manual typing, terminal use etc.
since the upgrade tzdata (2011c-0ubuntu0.10.04) to 2011d-0ubuntu0.10.04which I installed on Saturday, ntp updates seem to put me in GMT time.I've switched to manual time settings, as it does horrific things to my mythtv database!I'm not sure if its the upgrade, or the ntp time servers. My timezone is Australia/Tasmania.
I just reinstalled Ubuntu Lucid Lynx and an old problem has come back. For some reason I couldn't fix it even in my previous installation. The problem is the top gnome panel. See the photo below: As you can see, the network icon is not shown properly while the Me menu is being shown twice. I can't even restart or log out or shut down at this situation without pressing the keystroke to turn the power off.
Every time I reboot my computer the system time always comes up exactly 10 hours behind where it should be. So if I reboot it at 16:00 it comes up as 06:00.
This has only been happening since I got back from a trip to Australia, where I naturally changed the computer's timezone to match the local one. I'm now back in Central European Time which is 10 hours behind Australia's. This is on opensuse 11.3.
I've used the YAST date and time tool to set the timezone correctly, and /etc/localtime is set correctly:
I noticed today that my F13 date was one month out i.e October 30th instead of September 30th.Time was okay. I tried to adjust it manually but no success. Now if I try to start up I get to the first blue screeen but then it says something like "last mountpoint date was October 30th = now September 30th which is in the future" (not exact wording). Time zone is correct and not set to network time or UTC. I'm dual booting with WinXP and date and time is correct and Time Zone is correct. System time is correct. So now to get into F13 I have to manually set the system time to 30th October.Which is OK for the 1st reboot but reverts back to the correct date on the next reboot. WinXP boots ok.
Every time I reboot my computer the system time always comes up exactly 10 hours behind where it should be. So if I reboot it at 16:00 it comes up as 06:00.
This has only been happening since I got back from a trip to Australia, where I naturally changed the computer's timezone to match the local one. I'm now back in Central European Time which is 10 hours behind Australia's. This is on opensuse 11.3.
I've used the YAST date and time tool to set the timezone correctly, and /etc/localtime is set correctly:
I'm running windows 7 and the F12 Beta (although the same issue existed in my f11 distro) on an asus g71 bb. When ever I boot into windows my time is correct. If I boot into to F12 my time is wrong. Usually by 4 hours. If I change it in Linux when I boot into windows I end up switching the time on my windows partition. I tried searching the forum (rather casual I'll admit) and couldn't find any solutions.
I recently updated my Lucid to Maverick. I am running ubuntu on Lenovo Thinkpad w500. I am facing problems with day light savings. I changed couple times to reflect the correct time. Inspite of my correction, it is still displaying wrong time. Attached is the image of my error.
I have this server that runs Tomcat . this server sends mail with localhost as MTAthe local MTA is sendmail (with the default settings) . from time to time i have this strange thing and the emails it sends never reach the destination. the log shows it left the server , but looking at the logi see that the time on the log is wrong . sometime its correct and ometines its +2 hours. i guess this email are bounced at the destinationfor sending at future time . all this email that didnt reach the destination have this in common
I just used EasyTAG 2.1.5 under Ubuntu 9.10 to update the tags on my music files running on Rhythmbox 0.12.5, and now Rhythmbox shows that the runtimes (Time) of dozens of my mp3's are now 27:03:11. That means Rhythmbox thinks all those songs are 27 hours, 3 minutes, and 11 seconds long, which they are not. Some are now shown as 54:06:23. So far they are all playing correctly, but the slider at the top of the Rhythmbox window barely moves, making it difficult, if not impossible, to jump to different points in the songs. Nothing else seems to have been affected.
I have the following problem;When I concatenate several mp3 files the time duration is falsely detected by Rhythmbox when I open the newly created mp3 file. VLC Player however detects the correct time duration. I tried two ways of mergen the mp3's and both have the same falsely result. - mp3wrap- catI currently fixed it by opening the mp3 in VLC player and converted it again to a mp3 file which resolved the issue at hand. However this is not a solution I would like to have, nor a answer to what is the cause of the problem.So my question is simple -- what is the issue with the mp3 file and why is Rhythmbox indicating a falsely time duration?
System time was drifting ahead increasingly for several days time in the end. This is what I did with the clock about 6 hours "in the future":
Quote:
sntp -P no -r pool.ntp.org hwclock --systohc
i.e. I got the (more or less) exact time from the time server and set the hardware / BIOS timer with this value.I renamed "/etc/adjtime" to beginn with a clean slate. During reboot (shut down phase) I noticed a message saying something like: "hwclock set to system time". I checked in the BIOS and there was a new time about one hour early(!). The boot phase then reset the time again, this time several hours forward (usually two to six hours). This is an iterating process, with a net gain of several hours per boot. It is not always whole hours -- like in a time zone error but it involves also minutes. System is set to UTC as affirmed by the "date" command. What could be the cause of this behaviour of the clock / timer?
when I installed Ubuntu 9.10 I put in one time setting but it was wrong, and now I don't know where to change it. I tried to change the time preferences, but on reboot I am back to the wrong time.
I know the data is in there somewhere and I can change if I knew where it was.
I have a LAMP website with mysql backend with InnoDb engine for tables.I would like to be able to use mysqldump to take periodic dumps of the database - WITHOUT having to stop the mysql server (i.e. shutting down the website) for the duration of the backup. not even in the mySQL documentation. A lot of mention is made about mysqlhotcopy, but that only works for IMSAM tables - and is therefore of no interest/use to me.Does anyone know if (how?) I can use mysqldump to take a copy/dump of a database that is still being used?.A link to the official documentation would be very useful, since I want to make sure that I get this absolutely right.I am running on Ubuntu 10.0.4 LTS
I have a system running openSUSE 11.2 with Desktop and XEN kernel, as well as Windows 7 (not by choice though...). I have noticed a strange time issue, with Windows 7 and the desktop kernel the time is correct (like for example now: 1:32 PM) but in the XEN kernel it is ahead several hours (6:32 PM). If it was an issue between openSUSE and windows then I would think that it is a problem with the system clock but I don't know what would cause a time issue between kernels like that.
I would like to have my backup script that I am writing to create a sql dump of my database and go directly into a tar file. Does anyone know how I could do this with one command?
Is it possible to compress the mysqldump output into say db_backup.sql.tgz. Then add that to an existing archive e.g. backup.tgz in one command or on the fly to save space and deleting it?
I have one doubt, is copying /var/lib/mysql is a good alterntive to mysqldump?.
Because i use rsync to copy /var/lib/mysql for back up without dumping the database. I use rsync to do differential backup up so that it copies /var/lib/mysql to /var/tmp every one minute.
We are running an adserver with mysql as the database. We backup the database every hour and lately noticed that ads doesn't get delivered at the time of backup. The database size is 1.2 GB in which a single table ifself is 1.1 GB. Googling around the problem says this may be due to lock table feature in mysqldump and disabling it might solve the issue but i'm afraid whether this would be a problem. Can anyone please explain what lock table means and will it be a problem if i disable it or may be any other alternative solutions/assitance (other than master/slave or replication since we cannot afford it at this time) would be really helpful.
I've been running arch linux, with my clock set to UTC with no problem. Recently I installed slackware on a different partition. During the setup I chose to set my clock to 'local time' instead of UTC by accident. Now in slackware my clock shows the wrong time. Also in arch it shows the same wrong time.
I booted back into slackware and ran pkgtool to enter the setup again, and changed my time to UTC. But this makes no difference. My clock is still wrong in both slackware and arch. Do I need to reboot after changing my clock settings in slackware before it takes effect? how the clock or the setup works.
