impor SQL error

Discussion in 'Dedicated Server dan Colocation' started by warsito, 30 Sep 2015.

Thread Status:
Not open for further replies.
  1. warsito

    warsito Poster 2.0

    Messages:
    162
    Likes Received:
    1
    Trophy Points:
    18
    mas Tuan mau tanya ne. saya mau impor sql tapi kok kek gini ya. muncul nya http://prntscr.com/8m6v2x

    sebelum nya pakai linuk ini di ganti centos
     
  2. masiqbal

    masiqbal Expert 2.0

    Messages:
    863
    Likes Received:
    249
    Trophy Points:
    43
    Coba masuk aja dulu ke databasenya:
    # mysql -u user -p database
    mysql> source /home/user/file.sql
     
  3. warsito

    warsito Poster 2.0

    Messages:
    162
    Likes Received:
    1
    Trophy Points:
    18
  4. masiqbal

    masiqbal Expert 2.0

    Messages:
    863
    Likes Received:
    249
    Trophy Points:
    43
    service mysql nya apakah sudah jalan? Apakah bisa masuk ke databasenya?
     
  5. warsito

    warsito Poster 2.0

    Messages:
    162
    Likes Received:
    1
    Trophy Points:
    18
    sudah mas Tuan, kalau login ke phpmyadmin dah bisa. cuman mau impor aja ne muncul kek gitu terus
     
  6. masiqbal

    masiqbal Expert 2.0

    Messages:
    863
    Likes Received:
    249
    Trophy Points:
    43
    masuk ke database via console bisa gak?
     
  7. warsito

    warsito Poster 2.0

    Messages:
    162
    Likes Received:
    1
    Trophy Points:
    18
    tidak Tuan kalau console

    kalau buat DB baru bisa Tuan, yg tidak bisa itu impor nya. itu apa nya ya Tuan .?

    apa minta updat versi ya...?
     
  8. mustafaramadhan

    mustafaramadhan Hosting Guru

    Messages:
    3,237
    Likes Received:
    857
    Trophy Points:
    113
    Coba pakai:
    Code:
    service mysqld stop
    mysqld_safe --init-file=/path/to/1.sql >/dev/null 2>&1 &
    service mysqld start
    Ganti /path/to ke path sebenarnya.
     
  9. masiqbal

    masiqbal Expert 2.0

    Messages:
    863
    Likes Received:
    249
    Trophy Points:
    43
    coba: mysql --help
     
  10. masiqbal

    masiqbal Expert 2.0

    Messages:
    863
    Likes Received:
    249
    Trophy Points:
    43
    kalau pakai cara ini jangan lupa harus ada "USE <database>;" di dalam file sqlnya.
     
Loading...
Thread Status:
Not open for further replies.

Share This Page

Loading...