XAMPP setup preconfigured for IntegraMOD.

[Fubie]

Yes, you can use it. Just place your db file in c:xampphtdocsmysqldumperworkbackup

[Fubie]

oh, and create a new sql db in phpmyadmin per the tutorial.

[ayasha]

it is working <img> so far so good, at present, it is still dumping the data into the database.

now, how can i get this mysqldumper on my host to use for backing up and restoring my database?

[Michaelo]

What ever you do don't wash the dishes before restoring, I tried it once but never againà¢Ãƒ ¢Ã¢â‚¬Å¡Ã‚ ¬Ãƒâ€šÃ‚ ¦
Whats this bigdump thingy I only use phpmyadmin export is there a better way?

[ayasha]

ok, got the database in and when i go to open sites, and click on the one that i have been setting up, i get this


Warning: mysql_connect(): Access denied for user 'ayasha'@'localhost' (using password: YES) in C:xampphtdocsforumdbmysql4.php on line 54

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 571

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 572
phpBB : Critical Error

Could not connect to the database

i am wondering if i would not be better off to wait, until i can afford the amount of space i had before, and just setting up all the "testing" forums i had on a server somewhere and not my comptuer. if each one is going to be as hard to setup, but i am hoping it is just me and i will get the hang of it because if i could have all this on my HD i would only need 1 live forum.

and Mike, the MySqldumper looks to me like a seperate program you would install on your hosting to mangage large db's with, but i don't know, Fubie would be the better one to answer

[Fubie]

Big dump imports a large db into your sql db in chunks. It's 1 file and is very simple to use.

mysqldumper is more complex. It backs up manually or via a cron job.

You can download each [url=http]Here.[/url]

[Fubie]

cleo,

You need to edit your db in phpmyadmin to reflect your new domain and db setup.

Your domain on xampp will be localhost.

[ayasha]

well, one thing is for sure, i am sure getting an education doing this, what do i edit?

when i set up my forum, and i filled out the info on the install, i used 'localhost'

so is there somewhere else i need to edit?

edit: in the table phpbb_config, would i change

server_name graphicsplayhouse.com

to

server_name localhost?

again, i do apologize for asking so many questions.

[Fubie]

Edit your config.php to reflect your new db name and password.

go into phpmyadmin in xampp, open your new db from the left.

click on the SQL tab at the top.

You should get a large empty box.

Below in the code replace forum with the folder name you are using for your forum.

Then pasteit in the box and hit Go.

UPDATE `phpbb_config` SET `config_value` = '/forum/' WHERE `config_name` = 'script_path' LIMIT 1 ;

then goto that SQL tab again and past this in it.

UPDATE `phpbb_config` SET `config_value` = 'localhost' WHERE `config_name` = 'server_name' LIMIT 1 ;

Hit go.

Then see if your forum comes up.

[ayasha]

well, here is what i did

i named the database i created the same as the one i was using, used the same user name and pw.

the folder i have my forum in is named forum, so i did not have to change anything in that line

i ran both lines, and it changed and gave me the message everything was done ok,

but i still cannot get to my forum.

[Fubie]

Could you post the error if it's a new one?

[ayasha]

Warning: mysql_connect(): Access denied for user 'ayasha'@'localhost' (using password: YES) in C:xampphtdocsforumdbmysql4.php on line 54

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 571

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in C:xampphtdocsforumdbmysql4.php on line 572
phpBB : Critical Error

Could not connect to the database

doesn't look new to me, but i may be wrong

[Fubie]

can you confirm that mysql is running?

Thats a db connect error

[ayasha]

yes, it is running, i am just going to walk away and watch some tv for awhile.

i might even delete it all and begin again when i come back, just know i am getting a bit frustrated, and now my son i shome from school, and my hubby is up, so time to get his meds out and see what he needs today.

thank you so much for your help Fubie, and when i get back to this, if i still have the errors, i will let you know.

it is connecting with the im140 just fine, but not the one i added.

[Fubie]

ok <img>