[PHP-DB] Re: mysql problem importing data

[Budelak]

Hello Merlin,
Have you gone through the mysql manual located in the docs folder of mysql?
Budelak
Merlin wrote:
Hi there,

I have a data file with data seperated by semicolons. It is about 8MB big.
Now I just want to import it into mysql.
I tryed several things. First I took phpmyadmin, which resulted in  a white
page without error msg. Then I tryed it by hand with load data. This did not
work as well. No I installed myodbc and tryed to export it from MS Access.
This completly crashes my database server with this message:
 /usr/local/mysql/bin/safe_mysqld: line 1:  1067 Segmentation fault
nice --5 nohup
/usr/local/mysql/libexec/mysqld --basedir=/usr/local/mysql --datadir=/home/m
ysqladm/data --user=mysql --pid-file=/home/mysqladm/var/mysqld.pid --skip-lo
cking -u mysqladm >>/home/mysqladm/data/SARATOGA.err 2>&1
030807 00:00:45  mysqld ended
Has anybody an idea on how to import that data? Its nicely seperated by ;

Thanx for any help,

Merlin




--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL problem with RedHat 8

[Foong]

did you compile php with mysql support?

foong



"Daniel Elenius" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> Hi!
>
> I'm trying to connect to my mysql database using something like
>
>  mysql_connect( 'localhost', 'root', 'thepassword' )
> or die ( 'Unable to connect to server.' );
>
> But I get the error message:
> ?Fatal error: Call to undefined function: mysql_connect() in
> /home/daniel/public_html/index.php on line 21
>
> I have:
>
> [root@p85 /]# rpm -qa |grep sql
> php-mysql-4.2.2-8.0.5
> mysql-3.23.52-3
> mysql-server-3.23.52-3
> mysql-devel-3.23.52-3
>
> and:
>
> [root@p85 /]# rpm -q php
> php-4.2.2-8.0.5
>
> Someone mentioned these two settings in php.ini, which I tried with no
> success:
>
> register_globals = On
> short_open_tag = On
>
> phpinfo() says that php was compiled with '--with-mysql=shared,/usr'
>
> Can someone help me please?
>
> regards,
> --
> Daniel Elenius <[EMAIL PROTECTED]>
>



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySql problem..............

[Michael Mauch]

Rodrigo <[EMAIL PROTECTED]> wrote:

> I need import some data from a Paradox table, i used the script below,
> it worked just fine..but all the data was imported without the " ç
> or á or é ", understand??? portuguese words all this changes to
> some wierd caracter is there a way to fix this, since my table is
> a Paradox 4 ANSI INTL850. am i fried??

Probably not. Have a look at the iconv extension:


If you don't have iconv and can't install it, strtr() might help:


Regards...
Michael

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL Problem

[Javier]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Why don't you use  And verify "again" that mysql support
enable. Have you checked your webserver's conf. file?

[EMAIL PROTECTED] wrote:
| Hi, i've a problem with MySQL in my PHP pages. My PHP version is 4.0.1
i think. it's been installed with Redhat Linux 7.2 with default MySQL
support. (I've verified it). when i want to connect to my sample MySQL
database, it give me error :
| Call to undifined function mysql_connect
| with all MySQL functions, i've the same error. what's problem? and
what i can do? please somebody help me.
|
| Many thanks, Alan
|
| 
| mail2web - Check your email from the web at
| http://mail2web.com/ .
|


-BEGIN PGP SIGNATURE-
Version: GnuPG v1.0.6 (MingW32)
Comment: For info see http://www.gnupg.org

iEYEARECAAYFAjzquFwACgkQNcG5oyVditttwgCfSBwxiROlR3YBoTcK6TMX6HeT
xEMAnRdtYdzMB4IsAwqCgBZ2F0k3RNUE
=b/Xr
-END PGP SIGNATURE-


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

[PHP-DB] Re: MySQL problem

[Aron Pilhofer]

It means there is a problem with your query. I'm not familiar with the
die(1) and die (2) syntax. I'm not sure what that does, but you might try
echoing your error message from the query to see what message you get.

Hope that helps.

"Caleb Walker" <[EMAIL PROTECTED]> wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
> I keep on getting this error statement:
> Warning: Supplied argument is not a valid MySQL result resource in
> /usr/local/www/data/phone/insert2.php on line 10
> 2
>
> Can someone tell me what is wrong with the code below, I just cannot
figure
> it out... Thank you very much in advance.  I am using php4.
>
> 
>  session_start();
> include("info.inc.php");
>
> mysql_connect("$host","$user","$pass") || die(mysql_error());
> mysql_select_db("$db") || die(mysql_error());
>
>
> $q = mysql_query("SELECT FName, LName FROM user_info WHERE (FName='$FName'
&&
> LName='$LName')") || die(1);
> $view = mysql_fetch_array($q) || die(2);
> ?>
>
> 
> 



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php