Database error after transfer to new server

dyaaez · 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.

joem · 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?

dyaaez · 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

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

dyaaez · 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 ?

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

dyaaez · 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:

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

dyaaez wrote: Database tables Type: (MYISAM)

Aaaand? MySQLdump make dump anyway.

dyaaez · 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

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)

Vesta Control Panel - Forum

Database error after transfer to new server

Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Re: Database error after transfer to new server

Login • Register