1,105,208 Community Members

Import Table From Script In Xampp

Member Avatar
hwoarang69
Posting Pro
572 posts since Feb 2012
Reputation Points: -4 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 9 [?]
 
0
 

my xampp was giving me problem so i del it and download a new one. now the problem is that all my database and table got del.

however i did safe my old xampp folder before del it. if there a way i can get my sql table script from that folder. so that way i can just import the file in my new xammp?

in my old xampp folder i went in:
xampp > mysql > data and it as all my database and tables.

this is inside the >data folder: these are my tables

db.opt
user.frm
...

so i try to go in my localhost>phpadmin and import the user.frm file but iam getting a errer:

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? ' at line 1

which i dont get. how can there be a syntax error? i didnt wrote the script the xammp creates it for me. so that mean there shouldnt be any errors.

Member Avatar
pritaeas
mod_pritaeas
11,285 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,829 [?]
Skill Endorsements: 154 [?]
Moderator
Featured
Sponsor
 
1
 

Perhaps this SO thread can help.

Member Avatar
hwoarang69
Posting Pro
572 posts since Feb 2012
Reputation Points: -4 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 9 [?]
 
0
 

it said that you need .frm .myd and .myi files. but in my folder i only have .frm files.

Member Avatar
pritaeas
mod_pritaeas
11,285 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,829 [?]
Skill Endorsements: 154 [?]
Moderator
Featured
Sponsor
 
1
 

Have you tried it?

Member Avatar
hwoarang69
Posting Pro
572 posts since Feb 2012
Reputation Points: -4 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 9 [?]
 
0
 

yes and didnt worked also i my folder dont have .myd and myi files for some reason.

i looked under xammp>mysql>data

Member Avatar
pritaeas
mod_pritaeas
11,285 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,829 [?]
Skill Endorsements: 154 [?]
Moderator
Featured
Sponsor
 
1
 

Here's one more.

Question Answered as of 1 Year Ago by pritaeas
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
Tags Related to this Article