Jerome's Blog: 2011-09-25

Saturday, October 1, 2011

Baby

You know you love me, I know you care
Just shout whenever, and I'll be there
You are my love, you are my heart
And we will never, ever, ever be apart

Are we an item? Girl, quit playin'
"We're just friends," what are you sayin'?
Said "there's another," and looked right in my eyes
My first love broke my heart for the first time

And I was like baby, baby, baby, oh
Like baby, baby, baby, no
Like baby, baby, baby, oh
I thought you'd always be mine, mine

Baby, baby, baby, oh
Like baby, baby, baby, no
Like baby, baby, baby, oh
I thought you'd always be mine, mine

For you, I would have done whatever
And I just can't believe we're here together
And I wanna play it cool, but I'm losin' you
I'll buy you anything, I'll buy you any ring

And I'm in pieces, baby fix me
And just shake me 'til you wake me from this bad dream
I'm goin' down, down, down, down
And I just can't believe my first love won't be around

And I'm like baby, baby, baby, oh
Like baby, baby, baby, no
Like baby, baby, baby, oh
I thought you'd always be mine, mine

Baby, baby, baby, oh
Like baby, baby, baby, no
Like baby, baby, baby, oh
I thought you'd always be mine, mine

When I was 13, I had my first love
There was nobody that compared to my baby
And nobody came between us who could ever come above
She had me going crazy, oh I was starstruck
She woke me up daily, don't need no Starbucks

She made my heart pound
I skip a beat when I see her in the street
And at school on the playground
But I really wanna see her on a weekend
She know she got me dazin' 'cause she was so amazin'
And now my heart is breakin' but I just keep on sayin'

Baby, baby, baby, oh
Like baby, baby, baby, no
Like baby, baby, baby, oh
I thought you'd always be mine, mine

Baby, baby, baby, oh
Like baby, baby, baby, no
Like baby, baby, baby, oh
I thought you'd always be mine, mine

I'm all gone
(Yeah, yeah, yeah)
(Yeah, yeah, yeah)
Now I'm all gone
(Yeah, yeah, yeah)
(Yeah, yeah, yeah)
Now I'm all gone
(Yeah, yeah, yeah)
(Yeah, yeah, yeah)
Now I'm all gone, gone, gone, gone
I'm gone

How can I import a MySQL dumpfile into my database

Q. How can I import a MySQL dumpfile into my database? My old hosting provider gave me data.sql file. I do have access via ssh to server. I'm using CentOS Linux 5 server.

A. You can easily restore or import MySQL data with mysql command itself. First you need to login to your system using ssh or putty (from Windows based system). For example:

Type the following command at the shell prompt:

$ ssh loginname@server.hosting.com

Now type following command to import sql data file:
$ mysql -u username -p -h localhost data-base-name < data.sql

If you have dedicated database server, replace localhost name with actual server name or IP address:
$ mysql -u username -p -h 202.54.1.10 databasename < data.sql
OR use hostname such as mysql.hosting.com
$ mysql -u username -p -h mysql.hosting.com database-name < data.sql

If you do not know the database name or database name is included in sql dump you can try out something as follows:
$ mysql -u username -p -h 202.54.1.10 < data.sql

source: http://www.cyberciti.biz/faq/import-mysql-dumpfile-sql-datafile-into-my-database/