Page 1 of 1

sql database maybe lost

PostPosted: 27. December 2010 22:40
by 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?

Re: sql database maybe lost

PostPosted: 28. December 2010 01:10
by Altrea
The mysql database files in xampp are in the folder \xampp\mysql\data

Re: sql database maybe lost

PostPosted: 28. December 2010 01:17
by jose_rui_sa
Hi Altrea

So i just need to import?

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


open witch file?

Re: sql database maybe lost

PostPosted: 28. December 2010 02:54
by Altrea
jose_rui_sa wrote: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?

Re: sql database maybe lost

PostPosted: 28. December 2010 09:49
by 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...

Re: sql database maybe lost

PostPosted: 28. December 2010 10:16
by jose_rui_sa
i just remember....


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

Re: sql database maybe lost

PostPosted: 28. December 2010 13:30
by 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?

Re: sql database maybe lost

PostPosted: 28. December 2010 13:53
by jose_rui_sa
I'm Portuguese... So some english problem... :oops:


- 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.

Re: sql database maybe lost

PostPosted: 28. December 2010 15:44
by Altrea
jose_rui_sa wrote:- 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.

Re: sql database maybe lost

PostPosted: 28. December 2010 15:54
by 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)

Re: sql database maybe lost

PostPosted: 28. December 2010 16:33
by 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

Re: sql database found. virtuemark. smtp

PostPosted: 28. December 2010 21:34
by 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?