Little help needed TODAY - $10

[KillerDomain]

Little help needed TODAY - $15

I bought a 'song lyrics' website on eBay last week. All the files are uploaded and the DB is made but I need to know if someone can SSH into the account and load a file into the DB.

The seller said the file is too large for him to load and to ask my Host. I asked HostGator to do this and they said:

Thank you for contacting HostGator. This is what I am doing. root@gator660 [/home/anysong/www]# mysqldump --opt anysong_lyrics > anysong_lyrics.sqlroot@gator660 [/home/anysong/www]# mysqladmin drop anysong_lyricsDropping the database is potentially a very bad thing to do.Any data stored in the database will be destroyed.

Do you really want to drop the 'anysong_lyrics' database [y/N] yDatabase "anysong_lyrics" droppedroot@gator660 [/home/anysong/www]# mysqladmin create anysong_lyricsroot@gator660 [/home/anysong/www]# mysql -o anysong_lyrics < thelyricsfinder.sqlERROR 1062 (23000) at line 2031: Duplicate entry 'Björk' for key 2 No matter how many times I try this it will come out the same.

Can anyone here do this for me? Note I have no other files that can be used only what I got and uploaded.

$15 in it after DB job done/comlete.

Thanks,
Damien.

 

[Frikkle]

Is this a database file like a .sql? Have you tried sticking it in the database with phpmysql in cPanel? (I believe Hostgator uses cPanel...)

 

[KillerDomain]

Thanks, i got someone to install the db but i believe it is incomplete as many of the songs do not display the lyrics. I have to contact the seller, again.

The domain is: www.anysong.org

 

[bojomojo]

any how, i had a problem like this before and managed to solve it, let me know if you need any help, I can show you the way to an automated script for free of course