http://www.posteet.com/ Recent posteets posted to Posteet 60 http://www.posteet.com/view/833 mysql -D DATABASE -u USERNAME -p -h HOST --default-character-set=utf8 < FILE.sql [database] [mysql] [restore] ]]> grummfy Fri, 14 Mar 2008 21:02:11 +0000 database mysql restore http://www.posteet.com/view/667 # Boot on a live CD and open a console. sda1 is supposed to be the partition containing the OS # 1/ Restore GRUB mount -t proc none /dev/sda1/proc mount -o bind /dev /dev/sda1/dev chroot /dev/sda1/ /bin/bash /usr/sbin/grub grub > root(hd0,0) # 0->a, 1->b ... #1->0, 2->1 ... grub > setup(hd0) grub > quit # 2/ Check if partition is bootable fdsik /dev/sda fdisk > p # print the partition table fdisk > a # toggle a bootable flag fdsik > 1 fidsk > w # 3/ Reboot !! That's done [bash] [fdisk] [grub] [linux] [restore] ]]> spirit Mon, 14 Jan 2008 11:48:39 +0000 bash fdisk grub linux restore http://www.posteet.com/view/75 # Dump mysqldump -u user -p -h localhost --database base > base.sql # Restore mysql -u user -p -h localhost base < base.sql [dump] [mysql] [restore] ]]> spirit Thu, 11 Oct 2007 07:15:57 +0000 dump mysql restore