We're a community of 1076K IT Pros here for help, advice, solutions, professional growth and fun. Join us!
1,075,939 Members — Technology Publication meets Social Media
Username:
Password:
Lost login information?
Start New Discussion Reply to this Discussion

Import Table From Script In Xampp

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.

2
Contributors
5
Replies
3 Hours
Discussion Span
5 Months Ago
Last Updated
7
Views
Question
Answered
hwoarang69
Posting Pro
569 posts since Feb 2012
Reputation Points: 6
Solved Threads: 0
Skill Endorsements: 7

Perhaps this SO thread can help.

pritaeas
Posting Prodigy
Moderator
9,268 posts since Jul 2006
Reputation Points: 1,173
Solved Threads: 1,456
Skill Endorsements: 86

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

hwoarang69
Posting Pro
569 posts since Feb 2012
Reputation Points: 6
Solved Threads: 0
Skill Endorsements: 7

Have you tried it?

pritaeas
Posting Prodigy
Moderator
9,268 posts since Jul 2006
Reputation Points: 1,173
Solved Threads: 1,456
Skill Endorsements: 86

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

i looked under xammp>mysql>data

hwoarang69
Posting Pro
569 posts since Feb 2012
Reputation Points: 6
Solved Threads: 0
Skill Endorsements: 7
pritaeas
Posting Prodigy
Moderator
9,268 posts since Jul 2006
Reputation Points: 1,173
Solved Threads: 1,456
Skill Endorsements: 86
Question Answered as of 5 Months Ago by pritaeas

This question has already been solved: Start a new discussion instead

Post: Markdown Syntax: Formatting Help
 
You
 
© 2013 DaniWeb® LLC
Page rendered in 0.3172 seconds using 2.65MB