phpbb_db_backup

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

Thanks for the quick answer but i dont know what that means or how to do it .
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
Oleg
Former Team Member
Posts: 1221
Joined: Sat Jan 30, 2010 4:42 pm
Location: NYC
Contact:

Re: phpbb_db_backup

Post by Oleg »

As obscene as it may sound I think it's worth a shot to set post_max_size to 1g and memory_limit to 3g and try again...
Participate in phpBB development: Get involved | Issue tracker | Report a bug | Development board | [url=irc://chat.freenode.net/phpbb-dev]Development IRC chat[/url]
My stuff: mindlinkgame.com
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

Thanks but i`m totaly new to this . I looked for those lines in bigdump.php and they arent in it so i dont know how or where to do that but i`m still game to try if anyone can point me in the right direction .
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
Oleg
Former Team Member
Posts: 1221
Joined: Sat Jan 30, 2010 4:42 pm
Location: NYC
Contact:

Re: phpbb_db_backup

Post by Oleg »

These go in php.ini. Start by locating this file on your computer. Hopefully you have it and it has a bunch of stuff in it.

How much memory does your computer have?
Participate in phpBB development: Get involved | Issue tracker | Report a bug | Development board | [url=irc://chat.freenode.net/phpbb-dev]Development IRC chat[/url]
My stuff: mindlinkgame.com
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10423
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: phpbb_db_backup

Post by Noxwizard »

Command line is the fastest way. PHP will take a long time, especially if it's POSTing large amounts of data all the time.

Code: Select all

C:\xampp\mysql\bin\mysql.exe -u db_username -p db_password database_name < "C:\path\to\backup.sql"
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

Thanks guys .

Its a 2.200 gig amd athlon with 3 gigs of memory .I found the file and the entrys and i have time .

I wouldnt mind trying them both one after the other = do it once the one way and then delete it and try it again the other way as i want to learn how to do it . I understand the first way but havent got a clue how or where to do the comand line thing so i need another pointer for that please . Thanks for the help .....this is getting interesting .
Last edited by Popp Singh on Fri Apr 30, 2010 2:30 pm, edited 1 time in total.
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
User avatar
Noxwizard
Support Team Leader
Support Team Leader
Posts: 10423
Joined: Mon Jun 27, 2005 8:41 pm
Location: Texas, USA
Name: Patrick Webster
Contact:

Re: phpbb_db_backup

Post by Noxwizard »

Since it's Windows, it's just Start --> Run --> cmd
Then type in the command I gave, replacing the values with the correct ones of course.
[Support Template] - [Read Before Posting] - [phpBB Knowledge Base]
Do not contact me for private support, please share the question in our forums.
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

Thanks . I will try it .
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

I tried the first way and it got up to 7% and then i got a white screen and it stoped .
Then i tied the second way and i cant get that to work either . I`m sure i must have made a mistake changeing the code you posted and trying several combinations .

This isnt urgent and i have loads of time .
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51905
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpbb_db_backup

Post by stevemaury »

What is the path to your backup file?
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

C:\xampp\htdocs\dump\phpbb_db_backup.sql

And this is where phpbb3.0.7 PL1 is installed

C:\xampp\htdocs\phpBB3
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51905
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpbb_db_backup

Post by stevemaury »

Paste this into the command line:

Code: Select all

C:\xampp\mysql\bin\mysql.exe -u root -p  phpbb < "C:\xampp\htdocs\dump\phpbb_db_backup.sql"
If you get an error, write it down and post back.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

It said enter password . I wrote root and it said
ERROR 1045 <20000> : Acess denied for user "root"@"localhost" <useing password ; YES>
Then i tried writeing administrator as the password and got the same . Then i tried it with no password and clicking enter and nothing happened exept that it blinked at me .

This is getting like an agatha christy mystery to solve and the more i dont suceed the more i want to try . Its fun .
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 51905
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: phpbb_db_backup

Post by stevemaury »

Try this:

Code: Select all

C:\xampp\mysql\bin\mysql.exe -u root phpbb < "C:\xampp\htdocs\dump\phpbb_db_backup.sql"
By default xampp's username is root and there is no password. I probably should not have include the -p switch.
For REALLY good and VERY inexpensive hosting CLICK HERE

I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
Popp Singh
Registered User
Posts: 317
Joined: Thu Apr 22, 2010 4:31 pm
Contact:

Re: phpbb_db_backup

Post by Popp Singh »

Nothing happened exept that zonealarm , like each time i`ve tried , asked for permission to get into the net . I pressed allow .

Maybe i should start from the beginning again and put xampp and phpbb in again and do all the file changes again and try again ?
What i say is my opinion . If you dont like it or dissagree with it lets talk about it and try to come to an agreement . I`m not to old to learn or change my opinions if they are wrong .

http://www.youtopia.ws
Locked

Return to “[3.0.x] Support Forum”