Tags: restore

Sort by: Date / Title /

  1. Restore a database in mysql with a special charset
    5 months ago by grummfy
    #Param #HOST : host of your database : localhost, sql.free.fr, .... #DATABASE : your database name #FILE.sql : the file to restore #USERNAME : your username access
    mysql -D DATABASE -u USERNAME -p -h HOST --default-character-set=utf8 < FILE.sql
    View source | 0
  2. HOWTO Restore GRUB
    7 months ago by spirit and saved by 1 other
    1. # Boot on a live CD and open a console. sda1 is supposed to be the partition containing the OS
    2. # 1/ Restore GRUB
    3. mount -t proc none /dev/sda1/proc
    4. mount -o bind /dev /dev/sda1/dev
    5. chroot /dev/sda1/ /bin/bash
    6.  
    7. /usr/sbin/grub
    8. grub > root(hd0,0)    # 0->a, 1->b ...      #1->0, 2->1 ...
    9. grub > setup(hd0)
    10. grub > quit
    11.  
    12. # 2/ Check if partition is bootable
    13. fdsik /dev/sda
    14. fdisk > p      # print the partition table
    15. fdisk > a      # toggle a bootable flag
    16. fdsik > 1
    17. fidsk > w
    18.  
    19. # 3/ Reboot !! That's done
    View source | 0
  3. Myqsldump et mysqlrestore
    10 months ago by spirit
    1. # Dump
    2. mysqldump -u user -p -h localhost --database base > base.sql
    3.  
    4. # Restore
    5. mysql -u user -p -h localhost base < base.sql
    View source | 0

First / Previous / Next / Last / Page 1 of 1 (3 posteets)