phpMyAdmin Import

[TheMarvinglennlacuna]

I am newbie in PHPMYADMIN . I would get lost if i continue watching this. I stop 1:02 because he says 'EVERYTHING HAVE THAT' . -_- confusing!

[CodingDev]

@AnEight2 kso, This was one of the first few videos I had, was experimenting. Haven't done much since. Settings were screwed, too bad.

@deluxeassortment Read my above thing. I've since removed this account from my gmail and I plan on redoing the tutorials with the hopes my roommates won't come busting through my door like the Incredible Hulk.

[deluxeassortment]

TAKE THE MIC OUT OF YOUR THROAT

[unknownpit]

Thanks buddy it helped

[AnEight2]

DUDE HONESTLY,

Try to rehearse what it is that you want to do/say. And stop eating the microphone.

PRACTICE.

Keep doing it.

[unknownpit]

@AnEight2 Why don't you do a better job!

[bobsaget121]

YOu have a 50 MB File? I would try to split it up. Move different things to more text files and upload one after another ;)

[donnyvasquez]

How can i do for have 50M on Upload files on my DataBase Upload.

[ncbookz]

i need help bad friends, my csv will not replace the table, it only adds new lines help someone please help us.

we want to upload our csv files and replace the values already in and 1st line on our csv is our headers

[bobsaget121]

Try looking around for DROP IF EXISTS `tablename` then under that re-create the table ;)

[iloveReeperbahn]

haha it didnt work haha

[bobsaget121]

I found the error later on when trying to use a site with basically full javascript. I had used the web developer toolbar to disable javascript so i don't get random ass pop-ups but it worked too well and disabled the browser button :P

[fyralf]

yeah that toolbar is awesome. so what's the best way to turn a comma or tab delimited file into an sql file. i.e. "blah, blah, blah" to turn into "INSERT INTO TABLE Somethin VALUES ('blah','blah')" because i haven't been able to figure out the easiest way.

[bobsaget121]

like its a regular sql file yet has tabs before the sql?

Create Table `test` ( `id` int( 11 ) not null auto_increment, `test_text` text not null, Primary Key(`id`)

);

type deal?

[fyralf]

So it's a .csv or .txt or .xls file that needs to be a .sql file.

Maybe I'm just going about this the wrong way. I just want the data within this gigantic ACCESS/EXCEL file to be entered into my MySQL database so I can run queries on it.

[bobsaget121]

ah yeh, should be able to import the same way :) i was just using .sql as an example.

[fyralf]

yay i kinda figured out a way. i go .xls -> .csv then import the .csv file. it was still quite the bitch to search for all "\" and quotes and other characters that needed to be escaped. *sigh*, ok now to figure out the best way to import IMAGES into this database. I have to admit this is kind of fun. Thanks for ur help btw. do you have a blog or anything?

[bobsaget121]

i'm in the process of coding a custom blog for me :P i'll post a link on my profile when its done.