Sponsor:

Server and Web Integrator
Link:
Kloxo-MR logo
6.5.0 or 7.0.0
Click for "How to install"
Donation/Sponsorship:
Kloxo-MR is open-source.
Donate and or Sponsorship always welcome.
Click to:
Click Here
Please login or register. 2017-11-08, 02:09:23

Author Topic: sql restore problem  (Read 2433 times)

0 Members and 1 Guest are viewing this topic.

Offline cmdman

  • Senior Member
  • *
  • Posts: 297
  • Karma: +0/-0
    • View Profile
sql restore problem
« on: 2014-05-13, 14:07:41 »
iam trying to restore mysql db from backup taken from kloxo backup i get error..


Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: sql restore problem
« Reply #1 on: 2014-05-13, 14:13:23 »
What's happen if using 'sh /script/replace'?.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline cmdman

  • Senior Member
  • *
  • Posts: 297
  • Karma: +0/-0
    • View Profile
Re: sql restore problem
« Reply #2 on: 2014-05-13, 16:10:06 »
[root@server12 script]# sh replace
/usr/bin/replace: /usr/bin/replace: cannot execute binary file
[root@server12 script]#

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: sql restore problem
« Reply #3 on: 2014-05-13, 16:47:18 »
Sorry, I mean 'sh /script/restore'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline cmdman

  • Senior Member
  • *
  • Posts: 297
  • Karma: +0/-0
    • View Profile
Re: sql restore problem
« Reply #4 on: 2014-05-13, 16:57:57 »
[root@server12 script]# sh restore
Usage: ../bin/common/restore.php --restore/--list --accounts='domain-<domain1.com>,client-<client1>,domain-<domain2.com>' <backup-file> [--switchserverlist='oldserver1:newserver1,oldserver2:newserver2']
 Use --accounts=all to restore everything.
[root@server12 script]#

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: sql restore problem
« Reply #5 on: 2014-05-13, 17:05:06 »
So, you can restore all your data with 'sh /script/restore --restore --accounts=all yourfullpathbackupfile'.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline cmdman

  • Senior Member
  • *
  • Posts: 297
  • Karma: +0/-0
    • View Profile
Re: sql restore problem
« Reply #6 on: 2014-05-13, 17:07:59 »
no i just want only database to restore.. but why not works from panel its happening from long time

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: sql restore problem
« Reply #7 on: 2014-05-13, 17:16:06 »
Restore database from phpmyadmin and not from main panel.
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline cmdman

  • Senior Member
  • *
  • Posts: 297
  • Karma: +0/-0
    • View Profile
Re: sql restore problem
« Reply #8 on: 2014-05-13, 17:20:04 »
from php too same problem.. i get blank page error and panel get error i need to restart services...to access panel

mysitedb-mysqldb-any-1397440632.tgz i have only 120MB
but when i extract it has 750 mb file..
« Last Edit: 2014-05-13, 17:23:38 by cmdman »

Offline MRatWork

  • Administrator
  • The Elite
  • *****
  • Posts: 15,381
  • Karma: +112/-9
  • Gender: Male
    • View Profile
    • MRatWork Forum
Re: sql restore problem
« Reply #9 on: 2014-05-13, 17:45:04 »
You can try:
Code: [Select]
mysql -u root -pYOURROOTPASSWORD < YOURFULLPATHOFSQLFILE

or

Code: [Select]
service mysqld stop
mysqld_safe --init-file=YOURFULLPATHOFSQLFILE
service mysqld start
..:: MRatWork (Mustafa Ramadhan Projects) ::..
-- Server/Web-integrator - Web Hosting (Kloxo-MR READY!) --

Offline cmdman

  • Senior Member
  • *
  • Posts: 297
  • Karma: +0/-0
    • View Profile
Re: sql restore problem
« Reply #10 on: 2014-05-13, 17:59:21 »
ERROR 1064 (42000) at line 1: 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 'mysql-mysitedb.dump

Offline cmdman

  • Senior Member
  • *
  • Posts: 297
  • Karma: +0/-0
    • View Profile
Re: sql restore problem
« Reply #11 on: 2014-05-13, 19:18:19 »
step-1 followed
mysql -u root -pYOURROOTPASSWORD < YOURFULLPATHOFSQLFILE

its taken 45mints still shows same sessions nothing restored..


step-2 followed  below error

[root@server12 kwf]# service mysqld stop
Stopping mysqld:                                           [  OK  ]
[root@server12 kaf]# mysqld_safe --init-file=mysql-kafdb.dump
140513 17:18:25 mysqld_safe Logging to '/var/log/mysqld.log'.
140513 17:18:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
140513 17:18:28 mysqld_safe mysqld from pid file /var/lib/mysql/server12.pid ended
[root@server12 kaf]#

 


Top 10 Social Networking:    Facebook    Twitter    LinkedIn    Pinterest    Google Plus    Tumblr    Instagram    VK    Flickr    Vine
Click Here

Page created in 0.047 seconds with 17 queries.

web stats analysis
 
Mirror created by MasterkinG32.CoM