sql database maybe lost

[jose_rui_sa]

Hi,

I'm new in xamp world, and website creation world.


Last week i end my web-store, but i need to format the server.

So i copy the whole xamp folder, and copy again for the same directory, install everything.... But i cant load the properly sql database.

Where i can find it?

[Altrea]

The mysql database files in xampp are in the folder \xampp\mysql\data

[jose_rui_sa]

Hi Altrea

So i just need to import?

open mysql ->Import-> Search ????


open witch file?

[Altrea]

So i just need to import?

That depends on the source file you have.
Do you have a phpmyadmin .sql export file?
or a mysqldump dump?
or what else?

[jose_rui_sa]

in localhost/xamp.....


in myphpadmin i never export any file.


so maybe i have a mysqldump


like i sad.. i just backup the folder c:/xamp...

[jose_rui_sa]

i just remember....


i lost the information in the index page too...

[Altrea]

I think i don't get your problem.

Let me summerize:
- You have copied your old XAMPP folder to backup it
- You copied it back to your server
- now your databases are missing?
- and what information in the index page is missing?

[jose_rui_sa]

I'm Portuguese... So some english problem...


- You have copied your old XAMPP folder to backup it
yes

- You copied it back to your server
yes

- now your databases are missing?
correct

- and what information in the index page is missing?
I already change text, images... and other information in index page.
I have a index page... and inside i have a link for my webstore.

[Altrea]

- now your databases are missing?
correct

If this is the case, your problem could not be solved.
The mysql databases are all in the xampp\mysql\data folder. You have backuped the whole xampp folder, so all your mysql databases too.
If they are missing after copy the folder back, i have no idea whats going wrong there, sorry.

Either your backup was uncomplete, or you don't have copy your backuped xampp\mysql\data folder back, or you have done something else.

[jose_rui_sa]

the first time that i run the webstore i need to import some file named "localhost.sql"


0- i have the D.B working but empty and i fill up with items

1- then i copy hole xamp folder....

2- install the O.S

3- then copy the same folder for same directory...


but i can't enter in the D.B,i think that i need to import something (like localhost.sql, but with items)

[jose_rui_sa]

if i copy the whole D.B without import anything


jtablesession::Store Failed
DB function failed with error number 1017
Can't find file: 'jos_session' (errno: 2) SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '6a240233ad4587aedb17d4293213a8c2','1293550400','','0','1','0' )
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 40 bytes) in C:\xampp\htdocs\libraries\joomla\error\exception.php on line 117

[jose_rui_sa]

hi this already works...


i dont the problem... but is just working...


now i have one problem in virtuemark that i cant solve so many days ago.

the people outside my lan cant open properly the webstore.

the produtcs img dont show up.
the first time that i open the store, a cannot open page apear, if i refresh appear but no images.

How i change the Email message on xamp?