Results 1 to 6 of 6
-
26th Jan 2011, 11:17 AM #1OPMember
restoring database in phpbb3 - please help
Well, I have a backup file from 19.01. and I'm trying to restore the forum.
But when I try to do that, after about 10s I'm getting this error in browser:
The website encountered an error while retrievingCode:http://onelinkwarez.info/adm/inde.....
The file is in sql.gz format, and is 35.4MB big. Is it maybe problem in kloxo ? cuz my ftp is not working currently, so I can't unzip it(kloxo doesn't unzip big files)
It retrieve users and the first category(without content, just name), after that give me error.
Can someone help ?Cojba Reviewed by Cojba on . restoring database in phpbb3 - please help Well, I have a backup file from 19.01. and I'm trying to restore the forum. But when I try to do that, after about 10s I'm getting this error in browser: The website encountered an error while retrieving http://onelinkwarez.info/adm/inde..... It may be down for maintenance or configured incorrectly. The file is in sql.gz format, and is 35.4MB big. Is it maybe problem in kloxo ? :S cuz my ftp is not working currently, so I can't unzip it(kloxo doesn't unzip big files) It retrieve Rating: 5HQLessons.Net + HQLessons.Com + 8months of HQ shared hosting - 30$
Selling two themaPosters for 25$ or 15$ for each. Payza(AP) only. Contact me :)
Respected and trusted members: wf?9, Jimmy, ramicn, Matijasevic, rkze1
Cheap desktop apps development. Contact via pm or msn.
-
26th Jan 2011, 11:22 AM #2MemberWebsite's:
LulzCovers.com LulzTroll.comuse ssh to dump your database to mysql.
or use mysqldumper to dump the sql.Contact me for Traffic, SEO, WCDDL, Wordpress, IPB related Services or queries.
Template Designing, PSD to HTML, Wordpress
-
26th Jan 2011, 11:30 AM #3OPMember
can that be done with phpmyadmin ?
phpmyadmin : (Max: 8,192 KiB)
and I can't access to my server with putty...HQLessons.Net + HQLessons.Com + 8months of HQ shared hosting - 30$
Selling two themaPosters for 25$ or 15$ for each. Payza(AP) only. Contact me :)
Respected and trusted members: wf?9, Jimmy, ramicn, Matijasevic, rkze1
Cheap desktop apps development. Contact via pm or msn.
-
26th Jan 2011, 12:27 PM #4OPMember
tnx deathbliss very much! mysqldumper helped a lot! But now I have another problem, can someone help ? I've restored the database, but I can't see posts..
I can see, forums, subforums, description, members and permissions are also back, if you take a look, you can also see number of topics, for example
Movies
Watch and share your favorite movies. 6962 but I can't see posts
and also:
Cojba
Total posts:1 | Search user’s posts
(0.00% of all posts / 1.00 posts per day) Most active forum:XxX Videos
(4435 Posts / 443500.00% of your posts). Why this missleading ?HQLessons.Net + HQLessons.Com + 8months of HQ shared hosting - 30$
Selling two themaPosters for 25$ or 15$ for each. Payza(AP) only. Contact me :)
Respected and trusted members: wf?9, Jimmy, ramicn, Matijasevic, rkze1
Cheap desktop apps development. Contact via pm or msn.
-
26th Jan 2011, 04:04 PM #5Respected Member
Using programs like mysqldumper are great but they will quit on large files. SO you have to restart them from where they quit.
TRy restoring the posts only using mysqldumper. Or you can edit the backup file and copy and save the posts only part to try and restore by itself.
It is much better to use the mysql from the ssh login. SImple and never fails.
-
26th Jan 2011, 05:38 PM #6OPMember
fixed fixed fixed..... ) tryed about 4-5 times, until I finally succeed. thread can be closed now...
HQLessons.Net + HQLessons.Com + 8months of HQ shared hosting - 30$
Selling two themaPosters for 25$ or 15$ for each. Payza(AP) only. Contact me :)
Respected and trusted members: wf?9, Jimmy, ramicn, Matijasevic, rkze1
Cheap desktop apps development. Contact via pm or msn.
Sponsored Links
Thread Information
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Similar Threads
-
Need Help In Restoring Vbulletin Database on a vps with kloxo
By awaiz007 in forum Technical Help Desk SupportReplies: 6Last Post: 4th May 2012, 03:42 PM -
Database Error When Restoring With Bigdump
By blow in forum Server ManagementReplies: 12Last Post: 30th Aug 2011, 02:14 PM -
Problem After Restoring Vb 3.8.x
By Mulana in forum vBulletinReplies: 12Last Post: 23rd Mar 2011, 12:25 AM -
[Selling] phpBB3 database + files with ~9k users and 20k posts (warez)
By ageadm in forum Completed TransactionsReplies: 8Last Post: 4th Sep 2010, 06:50 PM -
Import old Database into New PHPBB3 with Mods
By goldie in forum phpBBReplies: 5Last Post: 25th Apr 2010, 12:28 PM
themaCreator - create posts from...
Version 3.22 released. Open older version (or...