## help backinp up DB

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:

### help backinp up DB

I need help backing up my database. I know how to do it on linux servers but I'm currently on a windows server and can't remmber the exact commands i need to dump my database.

i think the commands go something like this:

Code: Select all

c:\mysql\bin\mysqldump  -uusername -ppassword -ddatabase name > backup.sql
but when ever i enter that it doesn't work.
my DB is too large to backup up via phpmyadmin and even if i do it table by table its still too large cuz phpbb_post_text is something around 60MB.

anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:
anyone?

GreyDogz
Registered User
Posts: 200
Joined: Tue May 16, 2006 11:59 am
Create a batch file on the windows server

Code: Select all

@ECHO OFF
for /f "tokens=1-4 delims=/ " %%a in ('date/t') do (
set dw=%%a
set mm=%%b
set dd=%%c
set yy=%%d
)

SET bkupdir=C:\path\to\where\you\want\backups
SET mysqldir=D:\path\to\mysql
SET dbname=this_is_the_name_of_my_database
SET dbuser=this_is_my_user_name

@ECHO Beginning backup of %dbname%...

%mysqldir%\bin\mysqldump -B %dbname% -u %dbuser% -p%dbpass% > %bkupdir%\dbBkup_%dbname%_%yy%%mm%%dd%.sql
@ECHO Done! New File: dbBkup_%dbname%_%yy%%mm%%dd%.sql
pause

You could use the task manager to run it for you but delete the last 2 lines if you do or pipe it to a log file.

anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:
Thanks GreyDogz

im sorry for being such a noob at this but could u please tell me how to create a batch file on a windows server? This is my first time on a windows server and definatley my last

GreyDogz
Registered User
Posts: 200
Joined: Tue May 16, 2006 11:59 am
Is this your server or a hosting provider?

To create a batch file just copy the above text or any text into notepad, wordpad or my favorite notepad++ and save it as a filename.bat

Upload it to your windows server and give the correct permissions for you to run it.

To manually execute it just type the filename at the command prompt. If all works. You can add it to the task manager.

BTW: I hate windows servers too.

anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:
it's a host but i have root access.

i tried ur code and it didn't exactly work. it said:
'C:\mysql' is not reognized as an internal or external command

and then i find a backup file but its 0KB.
the path to mysql dir is C:\mysql...
BTW: I hate windows servers too.

i don't think their's anyone out there that likes em

GreyDogz
Registered User
Posts: 200
Joined: Tue May 16, 2006 11:59 am
Lets manually find the BU script Do you have this file:
C:\mysql\bin\mysqldump

Secondly, make sure you don't have a space in the command:
%mysqldir%\bin\mysqldump
I'm asking this because I would have thought the error you'd get would state C:\mysql\bin\mysqldump is not recognized as a command.

anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:
Lets manually find the BU script Do you have this file:
C:\mysql\bin\mysqldump

yes, i do have that file. and i made sure there were no spaces in the batch file but still got the same prob.

btw, i really apreciate the help greydogz

GreyDogz
Registered User
Posts: 200
Joined: Tue May 16, 2006 11:59 am
What version of mysql are you running? I just want to verify we are using the correct command and options.

Are you able to run the B/U manually at the cmd prompt?

anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:
GreyDogz wrote: What version of mysql are you running? I just want to verify we are using the correct command and options.

Are you able to run the B/U manually at the cmd prompt?

im really not sure what version im using. i think its 3.X.X or something.
and yes i can run the B\U manually at the cmd prompt.

a friend of mine once did it for me using a 2 lines of code. it went something like:

Code: Select all

C:\mysql\bin\mysqldump -uusername -ppassword -ddatabasename > backup.sql
it won't work atm. maybe because its wrong?

GreyDogz
Registered User
Posts: 200
Joined: Tue May 16, 2006 11:59 am

anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:
well i tried it ur way and it didn't work. said that i was not authorised. and then i tried it like this:

Code: Select all

-uusername -ppassword -d databasename
it worked but when i checked the file size it was 35KB. im sure that my database is much larger.

*will never get another windows server*

GreyDogz
Registered User
Posts: 200
Joined: Tue May 16, 2006 11:59 am
Try it without the "-d" but with just the DBname. I think the "-d" is telling it to just dump the structure and no data.

amanti27
Registered User
Posts: 14
Joined: Tue Sep 26, 2006 9:53 am
how do you find out what version you are using? does it make a difference?

anime-me
Registered User
Posts: 200
Joined: Sun Oct 02, 2005 7:16 pm
Location: K.S.A
Contact:
thanx a million greydogz. i finally backed up my database
i really apreciate ur help.