sql database maybe lost

Problems with the Windows version of XAMPP, questions, comments, and anything related.

sql database maybe lost

Postby jose_rui_sa » 27. December 2010 22:40

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?
jose_rui_sa
 
Posts: 10
Joined: 27. December 2010 22:35

Re: sql database maybe lost

Postby Altrea » 28. December 2010 01:10

The mysql database files in xampp are in the folder \xampp\mysql\data
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: sql database maybe lost

Postby jose_rui_sa » 28. December 2010 01:17

Hi Altrea

So i just need to import?

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


open witch file?
Last edited by jose_rui_sa on 28. December 2010 09:46, edited 1 time in total.
jose_rui_sa
 
Posts: 10
Joined: 27. December 2010 22:35

Re: sql database maybe lost

Postby Altrea » 28. December 2010 02:54

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?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: sql database maybe lost

Postby jose_rui_sa » 28. December 2010 09:49

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
 
Posts: 10
Joined: 27. December 2010 22:35

Re: sql database maybe lost

Postby jose_rui_sa » 28. December 2010 10:16

i just remember....


i lost the information in the index page too...
jose_rui_sa
 
Posts: 10
Joined: 27. December 2010 22:35

Re: sql database maybe lost

Postby Altrea » 28. December 2010 13:30

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?
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: sql database maybe lost

Postby jose_rui_sa » 28. December 2010 13:53

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.
jose_rui_sa
 
Posts: 10
Joined: 27. December 2010 22:35

Re: sql database maybe lost

Postby Altrea » 28. December 2010 15:44

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.
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 8293
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 10 Pro x64

Re: sql database maybe lost

Postby jose_rui_sa » 28. December 2010 15:54

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
 
Posts: 10
Joined: 27. December 2010 22:35

Re: sql database maybe lost

Postby jose_rui_sa » 28. December 2010 16:33

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
 
Posts: 10
Joined: 27. December 2010 22:35

Re: sql database found. virtuemark. smtp

Postby jose_rui_sa » 28. December 2010 21:34

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?
jose_rui_sa
 
Posts: 10
Joined: 27. December 2010 22:35


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 69 guests