[VoIP] CentOS MySQL

[Shane Young]

Well, let's start from the top.  Do you have mysql installed on your system?

If not, you'll need to get that installed.

You can type "which mysql" to see if mysql is installed.

shane at bridge01:~$ which mysql
/usr/bin/mysql

Assuming it is, you need to get the files onto your system and unzipped.


shane at bridge01:~$ wget http://nerdvittles.com/trixbox123/zipcodes.zip
--07:27:01--  http://nerdvittles.com/trixbox123/zipcodes.zip
            => `zipcodes.zip'
Resolving nerdvittles.com... 70.103.189.89
Connecting to nerdvittles.com[70.103.189.89]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 877,924 [application/zip]

100%[=========================================================================================================================================================>] 877,924       
669.83K/s

07:27:03 (667.76 KB/s) - `zipcodes.zip' saved [877924/877924]

shane at bridge01:~$ unzip zipcodes.zip
Archive:  zipcodes.zip
   inflating: zipcodes1.sql
   inflating: zipcodes2.sql
shane at bridge01:~$ mysql -u root -p < zipcodes1.sql
Enter password:
shane at bridge01:~$ mysql -u root -p < zipcodes2.sql
Enter password:
shane at bridge01:~$

Try that and let me know how far you get.



Quoting Lee Spenadel <lee at spenadel.com>:

> Thanks for the reply Shane.  I'm trying to get a weather by zip code
> application up on Asterisk as a dial extension.  I found the instructions at
> http://nerdvittles.com/index.php?p=160
>
> However, the instructions reference certain programming interfaces that
> would be installed on a TriBox PBX.  So the problem that I'm having is
> getting the zip code data in to a MySQL database.  I still have no clue how
> I'll get the AGI script working, if it will even work in my PBX, but right
> now the script can't even read the zip code data because I couldn't import
> it properly.  The TriBox PBX has this nice import feature in to MySQL that
> our version of Asterisk doesn't.  Not being a programming guru, especially
> in C, Pearl, etc, I was lost.
>
> I've attached the zip code archive.  There are two files that I need to get
> in to MySQL, unfortunately I do not know the format of the file; csv, how
> many fields, etc.
>
> Let me know what, if anything, you can do.
>
> Thanks
> Lee
>
> -----Original Message-----
> From: voip-bounces at ckts.info [mailto:voip-bounces at ckts.info] On Behalf Of
> Shane Young
> Sent: Tuesday, January 23, 2007 6:33 AM
> To: voip at ckts.info
> Subject: Re: [VoIP] CentOS MySQL
>
> I can help.  Tell me more...
>
>
> Quoting Lee Spenadel <lee at spenadel.com>:
>
>> Does anyone have experience with MySQL?  I'm trying to launch a
>> weather application on my Asterisk box and am having trouble importing
>> the zip code files in to a MySQL database.  Offers of help are welcome.
>>
>
>
>
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/
>
>
>
> _______________________________________________
> VoIP mailing list
> VoIP at ckts.info
> http://lists.ckts.info/mailman/listinfo/voip
> Project Web Page: http://www.ckts.info/
>
>