General :: Error At Restoring Dumped Sql
Aug 17, 2010
error at restoring dumped sql
I have backuped sql by mysqldump on mysql version 5.1.41. But when I restore this sql by command "mysql -uroot --default-character-set=utf8" my-db < my-sql.sql" I've got this error message.
Quote:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'barunarum',1,1,1,1,1,1,1,1,1,1,3,3,-1,5,1,-20,0,'','script|iframe',0,0,0,0,0,0,0' at line 1
View 4 Replies
ADVERTISEMENT
Oct 14, 2010
in my fedora machine i gave
mysqldump <database-name> > bakup.sql
in my solaris machine i gave
mysql <newly created dbname> < bakup.sql
it shows the below error
ERROR 1064 at line 25: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=latin1' at line 7
mysql version in my fedora machine is
mysql Ver 14.14 Distrib 5.1.47
mysql version in my solaris machine is
mysql Ver 12.22 Distrib 4.0.24
View 4 Replies
View Related
Mar 13, 2010
When I boot I briefly see 'Grub loading...' then I get dumped in 'sh:grub>'.
I can then boot up manually:
linux (hd0,1)/vmlinuz root=/dev/sda1
initrd (hd0,1)/initrd.img
boot
I'm very new at this, so all my attempts at correcting it has been through reading posts turned up by google searches. Previously, I was dumped at the grub_rescue> prompt (have another thread about that, but I think this is a new issue, so I'm hoping making a new thread won't bring any mod's wrath down on my head), but that seemed to solve itself through no influence of mine...
What I've tried to solve the 'sh:grub>' issue:
In /etc/default/grub:
I tried disabling quiet splash, in hopes there would be some lines that would give me a clue as to what is going on, but it jumps directly from Grub loading to sh:grub>
I tried commenting out Grub_Hidden_Timeout and setting it to a positive integer. I tried uncommenting GRUB_DISABLE_LINUX_UUID=true
In /etc/grub.d/10_linux:
I tried commenting out 'if [ -n ${have_grubenv} ]; then save_env recordfail; fi'
Then I tried typing 'search -f /boot/grub/grub.cfg' at the sh:grub> prompt and got 'error: no such device: /boot/grub/grub.cfg' which I guess meant all my previous attempts were void as grub couldn't even find grub.cfg. I've tried to reinstall grub with 'grub-install --recheck /dev/sda'. Then I found this thread and tried out "grub-setup -r '(hd0,1)' /dev/sda", hoping it would point to my grub.cfg as well. No such luck.
View 10 Replies
View Related
Jun 20, 2011
I am using RHEL 6. When i use CAP3 software for the first time it successfully resulted. But second time when i used, it's showing "segmentation fault (core dumped)". Even after restarting and reinstalling it showing same error. When i google, i found it some memmory related problem. But no clear information.
View 3 Replies
View Related
Apr 30, 2010
After upgrading to 10.04 from 9.10 Win7 wouldn't startup any more. So I tried this HowTo: [URL] to restore Grub2. But now each time I boot up I get this two lines: error file not found grub rescue> I have NO idea what to do.
[Code]...
View 9 Replies
View Related
May 12, 2010
After installing Lucid Lynx on a clean partition, as I usually do with all new releases, I had the idea of backing up my Firefox settings and stuff from the old installation with the Firefox plugin FEBE, to restore it into my new Firefox. It didn't go so well. I should've settled for just restoring the extensions, not settings and preferences too. Below is a copy of the Error Console, right after startup of Firefox. It seems something originally present (is it the Ubuntu One plugin?) was lost when I restored the FEBE files:
View 2 Replies
View Related
Jun 17, 2010
I would like to know if there is a way to repair a fedora 13 installation without using yum or using smart .Both applications are exiting with a "segmenttation fault".This happend after an general update and the installation of a couple of applications when the installer exited with an error message that indicated that there was not enough diskspace left.The message was wrong because there was plenty of space left and all of the applications were installed, just important programs used for changing the systems started crashing.Here is a small list of prgs that are crashing: yum , smart, system-config-firewall, system-config-printer, abrt-gui and I guess I might find easily more.Strange rpm seems to work.
View 12 Replies
View Related
Apr 9, 2011
When my c++ app crashes I would like to generate stackdump and display dumped register values. My app runs on Fedora Linux 2.6. I would like my program to be able to generate stackdump and display dumped register values when it crashes and the next time the user run's it, it will ask them if it is ok to send these to me so I can track down the problem. I can handle the stacktrace info but I don't know how to generate these two things.
View 1 Replies
View Related
Apr 25, 2011
I have a hard drive from a server that had a severe hardware failure. I have it attached via usb to the new server. I need to dump the database from the hard drive to a .sql file and then import the dump into the new server.
/mnt/external_drive/var/lib/mysql/ mysqldump -u root -p database name > backupdatabase.sql
My problem is, I enter in the root password, and it gives me an access denied error. I know this is the root password because that is how I am logged into the server. How can I test the credentials of the database that is located on the external hard drive? And, I've used all the credentials that could open this database (database user and root user) and still no go. If I can never get the password for the database on the external hard drive, what are my options?
View 1 Replies
View Related
Feb 8, 2010
Until my hard disk crashed I was running happily Debian Lenny with KDE 3.5.9. Rock solid, and blazingly fast on a AMD 1700+ processor with an 5 year old NVIDIA MX440. After the hard disk crash six months ago I decided to install Debian testing. Unfortunately Debian Testing comes with KDE4. The experience was horrendous. Instable, slow, dead slow, missing applications, limited setting capabilities, lacking functionality.
At the time I posted some comments on Debian and KDE forums. The KDE gurus blamed Debian, the Debian gurus blamed KDE. The answers I received included "KDE4 is still in development now, but it will be great, one day" In the mean time I replaced the VGA card with a faster one (FX5200) and indeed, the GUI became workable, but that is all to say about it. It still was slow. There are noticable delays between a mouse click and reaction. The system overall feels sluggish and contains many bugs. Even when I disable the graphic effects it doesn't become much better. In no way the snappyness of KDE 3 is achieved.
Almost two years ago I tried KDE4 (4.0 at the time) and I was scared. I posted some messages here and there, stating that KDE4 had become Vistalized. (Does that word need an explanation?) Two years further, and it is still on the edge of unusable. Last week I have installed Xfce. I had seen it before, but too many things were different and I switched back to KDE. This time I put some more effort in and got used to it in a day or two. Nothing wrong with Xfce, it is not even hard to use. For the time being Xfce will be the desktop I install on new machines instead of KDE.Too bad, KDE 3.5 was a great desktop. I am wondering whether there are more people who dumped KDE in favor of a less resource hungry bloated and Vista-like desktop?
View 14 Replies
View Related
Jun 18, 2010
I have performed the tar backup in my linuxbox by using the commandtar -cvpzf ring.tar.gz /m01/fordb/sqlThe ring.tar.gz is stored in /m01Now i need to restore the particular directory sql into the /m01/fordb/where i have deleted the sql directory
View 3 Replies
View Related
Sep 13, 2010
I've accidentally changed /usr/bin/php file on my server by running a cp command. I know this is bad, i just don't know how bad. Everything is working fine (websites using php), so i just wanted to know what this action could cause and also how can i restore original content
View 14 Replies
View Related
Jan 21, 2010
im trying to clone my ubuntu system installed in a laptop in case the laptop crashes.
But, first of all: when i try to restore the system in a new PC, could be incompatibilities because the hardware of the broken laptop and the new laptop is different?
I dont mind if i have to buy another laptop with the same processor type (i386, etc), but, for example, the type of the RAM could be cause of problems?
View 7 Replies
View Related
Jun 4, 2010
If I want to restore an full backup of AMANDA, will it restore the OS along with the files or does it just restore all the files in /
View 2 Replies
View Related
Feb 16, 2010
can i do a complete system restore on a toshiba netbook with linux op system, as ive bought one with admin name and password still on it, and i dont know the password to use the admin side of the netbook?
View 10 Replies
View Related
Oct 14, 2010
on a Linux pc I want to restore the contents of the DLT tape to /mnt directory,how to do itIf I just want to see the contents of the files, is it possible to read the contents irectly from tape without restoring to hard disk?
View 4 Replies
View Related
Feb 22, 2011
I mistakenly deleted the repo directory in the yum folder. Now my yum command does not work.i tried to rpmfusion but i couldnt find the rpm for fedora 7. How can i restore my repos. I didnt do any modifications. Only rpmfusion repo would do.
View 5 Replies
View Related
Jul 11, 2011
at work place I have an HP ProLiant DL580 with RedHat Enterprise Server 5.4 x64. Today I cloned this machine using clonezilla. What I would like to do is restore the image to VMWare machine for personal purpose (I cannot perform tests on production machine). But after restoring on VMWare I got "Kernel Panic". That's normal due to different hardware.
Now, is there a way to remove the Kernel Panic and correctly boot the machine? I ask our tech department for the RedHat CD1 to enter the "linux rescue" enviromnent, then try to re-read the hardware list with
# chroot /mnt/sysimage
# kudzu
View 3 Replies
View Related
Feb 3, 2010
I want to restore a HDD image I have to my laptop's HDD while booted off the Ubuntu Live CD.The laptop's HDD is unformatted and has no partitions.I expected this to work:$ sudo dd if=/path/to/backup.img of=/dev/sdaBut I'm tolddd: opening `/dev/sda': Permission denied.
View 1 Replies
View Related
Mar 20, 2010
Due to my inattention, tiredness (and probably stupidity) i've run "chown -R someuser:someuser /" and now all your base are belongs to us the files on the server belong to one user (lol).After system restart, apache, bind9, mysql, and adozen other applications don't start and fill their log files with permission errors.I haven't done any backups on system files, only on the db and website files.Please suggest some ways to revive my web server. I have only 2 month experience with linux,
View 1 Replies
View Related
Jun 30, 2010
I backed up my laptop months ago. Today i repartition the drive and used sysresccd with partimage to restore the HDD. I got a success msg after restoring however when booting i get a bootmgr missing error. How do i fix this?
View 2 Replies
View Related
Jan 27, 2010
I was having trouble creating a USB Startup Disk in Ubuntu and used the command:
sudo dd if=/dev/zero of=/dev/sdb bs=1M count=1
This was a mistake as my USB flash drive was on /dev/sdc. If I am understanding this correctly, the command above deleted the MBR and the partition table. This disk had a single "/storage" partition on it. I googled a solution and found that the "testdisk" program seems to be the most popular solution for things like this. I ran it, selected an "Intel/PC partition" type, set the partition to a non-bootable primary Linux partition, wrote it, and rebooted.
Whenever I run:
sudo mount -t ext3 /dev/sdb1 /storage
I get:
mount: wrong fs type, bad option, bad superblock on /dev/sdb1, missing codepage or helper program, or other error In some cases useful info is found in syslog - try dmesg | tail or so
Dmesg shows the following:
[20246.273941] EXT3-fs error (device sdb1): ext3_check_descriptors: Block bitmap for group 1 not in group (block 0)!
[20246.279376] EXT3-fs: group descriptors corrupted!
When I run:
sudo fdisk -l /dev/sdb
I get:
Disk /dev/sdb: 400.1 GB, 400088457216 bytes
255 heads, 63 sectors/track, 48641 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
[code]....
View 4 Replies
View Related
Jun 13, 2010
I've decided to give openbox a try with Debian testing. I set up my right-click menu exactly how I want it, and everything else is set up perfectly. I installed trayer and tint2, along with nitrogen. I added the following lines to my ~/.config/openbox/autostart.sh file, but things aren't loading/restoring as they should. Tint2 and trayer don't load at all, and nitrogen isn't restoring my wallpaper. All I get is a black screen with my cursor, but the ability to right-click and open the menu, so it's not like X is dead. I did set the default wallpaper by issuing the command nitrogen /home/john/Pictures/Wallpapers, where "Wallpapers" contains all of my background images.
Here is my autostart.sh file: Code: # Autostart file for openbox nitrogen --restore & sleep 2s && tint -c /home/john/.config/tint/.tintrc) & (sleep 2s && trayer --expand true --transparent true --alpha 255 --edge bottom --align right --expand true --SetDockType true --widthtype request --margin 130) & I do have proper content in the .tintrc file located in /home/john/.config/tint/tintrc. Am I doing something wrong here?
View 4 Replies
View Related
Jan 2, 2010
I'm trying to restore an image from a 40gb partition(6gb used) to a 100gb partition. I set everything up in gparted and and restored the partition image with clonezilla. In gparted, the partition shows the full 100gb partition with 6gb used, however when I boot windows and open the properties on the C: partition, it shows that it's only 40gb. Is there some setting to restore the partition image and use the full 100gb?
View 7 Replies
View Related
May 3, 2010
I was upgrading our lab's dhcp server to Lucid and it totally died. I have it running on a Debian recovery cd right now. I ran into a bug in gtk which I seem to have fixed, but now I have more serious errors. If I boot without a CD, I get dumped into a busybox shell after the machine fails to boot. From the live CD, I tried dist-upgrading again and it dies trying to build and install rsyslog with a broken pipe error. I am at a loss as to what to do from here short of reinstalling (which is the last option as this server has a lot of custom configs on it)
View 6 Replies
View Related
May 24, 2010
I am working on linux server with below specifications.Linux EDT 2008 i686 i686 i386 GNU/LinuxWhile checking the status of the server using the command 'opmnctl status' and when server is down the output is not getting redirected to file.I m using the command as,opmnctl status > abc.txt.
View 2 Replies
View Related
May 24, 2010
Several months back I backed up a windows hard drive using an ubuntu live cd and this commanddd if=/dev/hdx | gzip > /path/to/image.gzI now want to restore that image but so far have not been successfulI have tried to restore using this commandsudo dd if=/path/to/file.gz of=/dev/sdb1After some time has passed, the terminal reads23568129+1 records in23568129+1 records out12066882348 bytes (12 GB) copied, 1327.65 s, 9.1 MB/sIf I reboot to windows with the 2nd hard drive connected as a slave. I go to my computer to try and browse the files of the restored HD but when I double click the drive, windows saysthe disk is not formatted.I have also tried sudo dd if=/path/to/file.gz of=/dev/sdbAnd when I do this, the disk does not show up in places/my computer but it will show up in gparted and Disk Management
View 4 Replies
View Related
Oct 1, 2010
I took a backup of a guest OS running in an LVM.When I took the backup I created a snpashot of LVM and mounted thatsnapshot in some location.Used rsnc to copy its contents to a USB drive.Can I boot "somehow"from this copy of Guest OS which is now in USB drive?I am using KVM on 64 bit 10.04.
View 1 Replies
View Related
Mar 8, 2011
I save my whole system to a .tar.gz file weekly except for the /proc content. I have used this backup a few times to restore my system without issue.
Last time I restored, I discovered the following 2 issues I home somebody can explain:
#1: while extracting the .tar.gz using tar xzvf filename.tar.gz, I get the following error near the end of the restore process "tar: Incorrect Length". This error only occurs when I boot the system with the slackware 12.1 disc 1 CD. It does not occur if I try to restore from my working system, same file. Other than this, everything seems to be restored properly and the system boots up properly. I am just concerned by the meaning of this error.
#2: After restore, I do lilo -C /mnt/etc/lilo.conf to make sure the systems boots up properly. This works... however, I have discovered that just this won't make module autoloading work after the restore. When booting the restored system, no module autoload !
I have correct this by just entering setup when booted up using the slackware 12.1 disk 1 CD and going thru addswap, set target without format and the going thru the configuration menu and cancelling all question.
Why would modules not load automatically ?
View 4 Replies
View Related
Jul 19, 2009
We are doing some disaster recovery exercises with CentOS 5. One of the things we want to do is be able to restore to our old production server. However, after restoring the partitions the boot loader starts and then does nothing other than displaying the location of the kernel image at the top of the screen.
If I use the installation CD to boot and chroot into the system everything appears to work fine. I am not sure why the system isn't working right.
View 1 Replies
View Related
