Xepher.Net Forums

Content => Web Design => Topic started by: griever on January 31, 2006, 05:19:45 pm

Title: i've broken my site...again
Post by: griever on January 31, 2006, 05:19:45 pm
Hey, guys, I did a really stupid thing.  I was going to fix a bunch of typos in a table and thought that I could fix them in excel, then upload them into the table.  I fixed the typos, but I can't seem to get the file uploaded.  I thought I was being good...I saved each table as a csv (not for excel) file, with all the "" and ; so forth.  Whenever I try to do the import feature, it doesn't seem to work. :(  Can anyone help me?

EDIT:  I've been messing around with it for most of the afternoon...so far, my best luck has been:

EDIT:SQL code removed by admin... was screwing up sql in forum upgrade.

The 3 rows that get put in are blank.  Other variations include only one row with partial information, or no rows are put in, even though it says that the upload has been a success.
Title: i've broken my site...again
Post by: Xepher on February 01, 2006, 12:36:40 am
Umm... you haven't even mentioned WHAT you're importing this thing into? Are we talking a forum with an import feature or something?
Title: i've broken my site...again
Post by: griever on February 01, 2006, 06:08:08 am
Oh, oops...it's the phpmyadmin tool....  But I got a friend to look at it and he said my CSV file was weird looking.  He said that if I open the file in Notepad though, I can just cut and paste the stuff back in it, then said I should save it as a sql file instead.
Title: i've broken my site...again
Post by: Xepher on February 02, 2006, 05:58:45 am
Yeah... import into SQL has to be an SQL file, not CSV. CSV is just the values seperated by commas (Comma Seperated Values) SQL on the other hand is more like a script... it has all the commands (SQL "Statements") that you need to recreate a table. Unless PHPmyadmin has some trick of feature the translates CSV, then it won't work. I haven't used it in a while, so it might have that feature and I just don't know.
Title: i've broken my site...again
Post by: griever on February 02, 2006, 06:45:49 am
Ahh...that would explain it.  I doubt I'll ever forget this lesson though...it was a stressful day and a half! ^_^