Vesta Control Panel - Forum

Community Forum

Skip to content

Advanced search
  • Quick links
    • Main site
    • Github repo
    • Google Search
  • FAQ
  • Login
  • Register
  • Board index Main Section Database Server
  • Search

Database error after transfer to new server

Questions regarding the Database Server
MySQL, PostgreSQL, MariaDB, Percona Server, phpMyAdmin, phpPgAdmin
Post Reply
  • Print view
Advanced search
18 posts
  • 1
  • 2
  • Next
dyaaez
Posts: 21
Joined: Fri Mar 06, 2015 6:19 pm

Database error after transfer to new server
  • Quote

Post by dyaaez » Tue Jun 30, 2015 9:34 am

Hello,

2 problems after transfer to new server

After transfer Admin user to new server, alots of database tables lost .
And when I browse website only (default.domain) appears, Index now already in directory

what`s this? what happend? or I lost my website?

Please I need help

Regards,
Dyaa.
Top

joem
Posts: 378
Joined: Thu Nov 13, 2014 8:33 am

Os: CentOS 6x
Web: nginx + php-fpm
Re: Database error after transfer to new server
  • Quote

Post by joem » Tue Jun 30, 2015 9:45 pm

dyaaez wrote:Hello,

2 problems after transfer to new server

After transfer Admin user to new server, alots of database tables lost .
And when I browse website only (default.domain) appears, Index now already in directory

what`s this? what happend? or I lost my website?

Please I need help

Regards,
Dyaa.
How did you go about transferring these sites?
Top

dyaaez
Posts: 21
Joined: Fri Mar 06, 2015 6:19 pm

Re: Database error after transfer to new server
  • Quote

Post by dyaaez » Tue Jun 30, 2015 11:26 pm

joem wrote:
dyaaez wrote:Hello,

2 problems after transfer to new server

After transfer Admin user to new server, alots of database tables lost .
And when I browse website only (default.domain) appears, Index now already in directory

what`s this? what happend? or I lost my website?

Please I need help

Regards,
Dyaa.
How did you go about transferring these sites?
By applying this toturial: https://vestacp.com/docs/#how-to-migrat ... her-server
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Database error after transfer to new server
  • Quote

Post by skurudo » Wed Jul 01, 2015 7:09 am

dyaaez wrote: After transfer Admin user to new server, alots of database tables lost .
And when I browse website only (default.domain) appears, Index now already in directory
You can look inside archive and find, what databases in it
Top

dyaaez
Posts: 21
Joined: Fri Mar 06, 2015 6:19 pm

Re: Database error after transfer to new server
  • Quote

Post by dyaaez » Wed Jul 01, 2015 11:03 am

skurudo wrote:
dyaaez wrote: After transfer Admin user to new server, alots of database tables lost .
And when I browse website only (default.domain) appears, Index now already in directory
You can look inside archive and find, what databases in it
How to look inside archive ?
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Database error after transfer to new server
  • Quote

Post by skurudo » Wed Jul 01, 2015 12:10 pm

dyaaez wrote:You can look inside archive and find, what databases in it
ssh console -> mc and press to archive or
ssh console and unpack manually
Top

dyaaez
Posts: 21
Joined: Fri Mar 06, 2015 6:19 pm

Re: Database error after transfer to new server
  • Quote

Post by dyaaez » Wed Jul 01, 2015 2:10 pm

skurudo wrote:
dyaaez wrote:You can look inside archive and find, what databases in it
ssh console -> mc and press to archive or
ssh console and unpack manually
DB imported, but lost more tables
Database tables Type: (MYISAM)

look to image:
Image
Last edited by dyaaez on Wed Jul 01, 2015 2:13 pm, edited 1 time in total.
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Database error after transfer to new server
  • Quote

Post by skurudo » Wed Jul 01, 2015 2:12 pm

dyaaez wrote: Database tables Type: (MYISAM)
Aaaand? MySQLdump make dump anyway.
Top

dyaaez
Posts: 21
Joined: Fri Mar 06, 2015 6:19 pm

Re: Database error after transfer to new server
  • Quote

Post by dyaaez » Wed Jul 01, 2015 2:16 pm

skurudo wrote:
dyaaez wrote: Database tables Type: (MYISAM)
Aaaand? MySQLdump make dump anyway.
I restored backup by following that toturial:
https://vestacp.com/docs/#how-to-migrat ... her-server
Top

skurudo
VestaCP Team
Posts: 8099
Joined: Fri Dec 26, 2014 2:23 pm
Contact:
Contact skurudo
Website Facebook Google+ Skype
Twitter

Re: Database error after transfer to new server
  • Quote

Post by skurudo » Wed Jul 01, 2015 2:20 pm

If backup was made bad (not all db in there or mysql fail), then you see, what you see.
As I wrot before, try to unpack db and import manually (in ssh console)
Top


Post Reply
  • Print view

18 posts
  • 1
  • 2
  • Next

Return to “Database Server”



  • Board index
  • All times are UTC
  • Delete all board cookies
  • The team
Powered by phpBB® Forum Software © phpBB Limited
*Original Author: Brad Veryard
*Updated to 3.2 by MannixMD
 

 

Login  •  Register

I forgot my password