Unable to read the database backup file | Wordpress Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_Feed Topic RSSsp_TopicIcon
Unable to read the database backup file
September 2, 2014
3:17 pm
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

Hello,

I am trying to build a website to work with. Before working further to it i just wanted to be sure if i could backup the whole thing and restore the site when Necesary.

Most important was that it must have an option to move my website to another domain or place.

I am trying this plug in and i cannot work it out.

Making a backup is very easy. its working like a charm.

The webpage backupped is on the danpajo.com domain

I want to appear the restored site under danpajo.nl. This domain is for now forwarded to the map testsite in my root. Now the start of the root positioning of danpajo.nl is that point.

Despite what details i give i get the an error message: Unable to read the database backup file

Then i thought it must be the domain forwarding. So I unplugged danpajo.nl off the map testsite.

I made the Install directory /home/strato/http/premium/rid/29/67/51662967/htdocs/testsite/

 the same as the url http://www.danpajo.n.....estsite/ 

Still the error, 

I tried to do it with the danpajo.com credentials also.. problem there was the domain was forwarding to a map fromwhere to start its file structure. 

But even after taking away that problem.

The same error message is showing op.

Unable to read the database backup file /home/strato/http/premium/rid/29/67/51662967/htdocs/testsite//administrator/backups/database-sql.sql , database was not imported!

I noticed the double slash so i removed the slash after testsite in my Install directory settings.

Still the same error message is showing up. But without the double slash before administrator .

 

Can you tell me what i am doing wrong? or give me any advice?

thanks in advantage

jap 

September 2, 2014
3:43 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

If you've split the backup archive into multiple smaller pieces, make sure you restore each of the archive files, then at the last one continue with the mysql restore.

 

Ovidiu

September 3, 2014
8:59 am
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

Hello,

I select all parts of the backup, upload them to the destination place. When they are all there i start extract them. That's working fine.

Then i have to click continue.. but the error message still appears.

I opened the uploaded .tar file and went to the administrator/backup map. In there there is only a index.hmtl file and no .sql file.

What am i doing wrong?

September 3, 2014
10:31 am
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

Okay i found the sql problem

There was a huge file in my backup . I deleted it and now the sql file is loading.

After the extraction of the files and the database setup its telling me everything is working now.

When i go to the site danpajo.nl i get a white screen.

After looking in my files on the new domain i noticed not all folders and files are restored.

I miss the plugins for example.

Then i tried to manually download the .tar files, upload them to the new domain with XCloner.php and TAR.php with it. Start XCloner.php manually and fill in the details.

Same thing is happening. Not all files and maps are restored.

What is wrong now?

jap

September 3, 2014
11:17 am
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

Okay,

I've sorted it out a littlebit more.

I noticed i had two maps in my root. a Blog map and a tmp map with to files in it. I removed both maps because i couldnt find out where they are for.

After removing the two maps the xcloner script did his work. I cloned the site, extracted the files and everything went on the new server.

Then i updated my database and this went good also. Database is filled with my details.

Then after going to the new site danpajo.nl i get a white screen. I tried to go to danpajo.nl/wp-admin also a white screen.

i am almost there i guess but i cannot find out how to solve this white screen problem.

When i compare both databases the new database is smaller as the old one is!

I hope you can help me out.

jap

September 3, 2014
12:15 pm
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

The restored site files do have different permissions as the backed up site.

How can i back up my permissions also?

because i guess thats the problem.

Database import is going fine now.

September 3, 2014
1:54 pm
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

permission backup is working also. I forgot to check the checkbox.

Still white screen after restore.

I will try the backup now without changing the domain from .com to .nl

September 3, 2014
2:08 pm
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

Okay, 

its not the domain thing.

some way some how after restoring i get a blanc screen.

Files are in the right place, permissions are good, database is filled up with details

I don't know what to do anymore.

Can you please give me an advice?

Jap

September 3, 2014
5:38 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Please enable the php errors display for your site, you might get more details on the white screen issue, make sure all files are restored from the backups, better extract each backup archive manually and restart the restore process with the "Skip files restore" option checked.

 

Ovidiu

September 3, 2014
5:41 pm
Avatar
Jap
Member
Members
Forum Posts: 9
Member Since:
September 2, 2014
sp_UserOfflineSmall Offline

php errors is wp-debug mode true in my config file?

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
Andy: 21
D: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10030
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Omar Vera
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0