Linux Install :: Gcc:cannot Specify -o With -c Or -S And Multiple Compilations
I GET AN ERROR MESSAGE WHILE DOING MAKE OF MYSQL
ERROR GOES SOMETHING LIKE THIS:
Error while make in Mysql exit 1;fi
gcc:cannot specify -o with -c or -S and multiple compilations
[make 2]; ****[my_new.0] error1
[make 2]: leaving dir /usr/local
[make 1]: *** [all-recursive] Error1
i have tried using 2 diffrent versions of mysql
i am build a LAMP configuration on my pc with rhl9 in text mode using
CFLAGS="-O3"
CXX=gcc
CXXFLAGS="-O3
-mpentiumpro
-mstack-align-double
-felide-constructors
-fno-exceptions -fno-rtti"
./configure
--prefix=/usr/local/mysql
--with-extra-charsets=complex
--enable-thread-safe-client
--enable-local-infile
--enable-assembler
--disable-shared
--with-client-ldflags=-all-static
--with-mysqld-ldflags=-all-static
View Complete Forum Thread with Replies
Related Forum Messages:
JOIN Issue On WIndows Install But Not Linux Install
I am using MySQL 5.0.15 on windows and cannot run this query: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25 I receive: ERROR 1054 (42S22): Unknown column 'a.createdby' in 'on clause' But this query DOES work under my linux 5.0.0-alpha! I can modify the SQL Statement to the following and it works fine: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id RIGHT JOIN building b ON a.sortcode=b.sortcode WHERE a.sortcode like '1,2,1,6%' LIMIT 0, 25 .
View Replies !
Linux To Install
I am creating a dedicated DB server running mysql. What is the best linux to install for this?Also the db server will have its own ip is there any other additional security measures that should be taken?
View Replies !
How Do You Install MySQL 5.0 Server And Administrator On Red Hat Enterprise Linux 3 WS
Could someone point me to instructions for installing MySQL 5.0 server and administrator on a Red Hat Enterprise Linux 3 WS system? I just freshly installed the system and deliberately did not select MySQL serveras part of the installation I downloaded the 5.0 rpm Community Server edition, and that installed fine. My problems came while trying to build the administrator. Basically, I got caught up in a loop of incompatable modules: # rpm -i mysql-3.23.58-16.RHEL3.1.i386.rpm warning: mysql-3.23.58-16.RHEL3.1.i386.rpm: V3 DSA signature: NOKEY, key ID 025e513b error: Failed dependencies: perl-DBD-MySQL is needed by mysql-3.23.58-16.RHEL3.1 MySQL conflicts with mysql-3.23.58-16.RHEL3.1 Suggested resolutions: /var/spool/up2date/perl-DBD-MySQL-2.1021-3.i386.rpm If up2date the suggested resolution, it says I need a library from mysql-3.23.58-16.RHEL3.1.i386.rpm. I will gladly read the "manual" or docs, and would love a pointer to them.
View Replies !
Using Linux Symlinks W/Multiple MySQL Instances
We run multiple instances of MySQL on Linux. Each instance has its own directory structure. Along with other databases, each customer has a 5GB non-updating database that is used only for reference. Currently we have multiple copies of this database, which takes up a lot of disk storage. Since this particular database does not get updated, is it okay to have a single copy of it in a commonly accessible location and give the separate instances of MySQL access to it through symbolic links?
View Replies !
Linux RHE5 Startup Script For Multiple MySQL Instances
I have 2 instances of mysql 5.0.67 installed on one server. They are under 2 separate linux accounts (mysql & mysqldev). Each is installed in a non-standard location: mysql: /opt/mysql/5.0 mysqldev: /opt2/mysql/5.0 Each uses its own data directory: mysql: /ua01/mysqldata mysqldev: /ua03/mysqldata I have ONE /etc/my.cnf file owned & grouped as mysql. The my.cnf file contains the following (commented lines at beginning and end of the file are omitted): [mysqld_multi] mysqld = /opt/mysql/5.0/bin/mysqld_safe mysqladmin = /opt/mysql/5.0/bin/mysqladmin # Here follows entries for some specific programs # The MySQL server for STAGING [mysqld1] mysqld = /opt/mysql/5.0/bin/mysqld_safe mysqladmin = /opt/mysql/5.0/bin/mysqladmin port = 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M # TNC specifics basedir=/opt/mysql/5.0 ledir=/opt/mysql/5.0/bin datadir=/ua01/mysqldata log=/opt/mysql/admin/log/cricket.log log-error=/opt/mysql/admin/log/cricket.err pid-file=/opt/mysql/admin/log/cricket.pid log-bin=/dbarchive/mysql/cricket-bin.log....
View Replies !
Win To Linux
I have set up a website on a windows machine using PHP MySQL but I want to port this over to a Linux machine. Is it possible for me to simply copy over the MySQL data files e.g. .frm .myi .myd files over to the Linux machine and place them in the appropriate folder after creating the database?
View Replies !
GUI For Linux
suggest the best GUI of MySQL for Linux with Store Procedure support(Create/Update). Better if also supports triggers etc.
View Replies !
Linux
i installed mysql(usr/local/mysql) on linux but its not starting showing me error like Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) though mysql.sock file exists(linked) in tmp directory wont helped me.
View Replies !
Running 4.1 And 5.0 On Linux
Question: How can I run 4.1 and 5.0 simultaneously on linux - Suse 9.3 in particular? My goal is to do no harm to my current 4.1 setup. Can the 4.1 and 5.0 rpm's play nice together? Can I use the rcmysql commands for running multiple versions?
View Replies !
Upgrade From 3.23 To 4 In Linux
I have an installation of MySQL 3.23 located in /usr/local/mysql.3.23.51, which is working perfectly. Now I installed in /usr/local/mysql.4.0.14 the binaries for a new version (4.0.14 of course), and don't know how to start using it instead of the older one. I have a link: /usr/local/mysql pointing to /usr/local/mysql.3.23.51 and some few databases in that directory. My data files are in MyISAM format. How do I migrate the database files? How do I tell Linux to use this version? I never did a task like this in Linux, for I always used MS Operating Systems, so please be as clear as possible... In fact, I didn't understand the MySQL manual about this topic.
View Replies !
MySQL V4.0 -> Red Hat Linux 9
I'm having great problems trying to install the latest MySQl RPM package onto my Red Hat Linux OS. There is already MySQL v 3.0 pre-installed with the RH Linux distribution disk but I can not seem to get any of the functions working on it. So I have now dopwnloaded the latest version hoping that this will fix the error. I have managed to install the MySQL-shared-compat-4.0.1-0.i386.rpm but i'm getting the following error message when I install MySQL-server-4.0.1-0.i386.rpm : Code:
View Replies !
Low Performance With Linux SMP
I use #mysql -V mysql Ver 12.21 Distrib 4.0.15, for suse linux (i686) with a SMP-kernel When I used this version with a kernel not SMP mysql was very very fast but now with the SMP-kernel the mysql is very very slow. I takes several minutes to make an INSERT on a table with near 50.000 Records Is there any problem with mysql an SMP? is a problem of the version I have installed?
View Replies !
Mysql On Linux
I am interested in connecting to my MySql database that is running (default install) on FC4. I want to connect to the db with my Windoze machine using MySql Query Browser. Both machines are behind a router; the gateway is 192.168.0.1. The Linux ip address is 192.168.0.50 and the windows is 192.168.0.11 (both static). I guess I need to learn how to determine the mysql host and port when connecting. I thought it would just be 192.168.0.50 and 3306 respectively, it's not working.
View Replies !
MySQL And Linux
I am pretty new to the MySQL/Linux worlds. Each time I want to use MySQL, I have to start the program under the root account. Are users other than "root" allowed to access the program? If so, how is it done? It would be nice if I didn't have to continuously log into root every time I would like to use MySQL.
View Replies !
Debian Linux
I have mysql 4.1.8 from backports.org running on stable debian linux. I have 3 medium-scale web apps running off this same db server. the log files on this machine are becoming larger every day. finally this morning the db server hung up and after some detective work i found the culprit was the log files. they are huge, 3 gigs sometimes, and when logrotate tries to zip them the whole thing geeks up. in the /etc/mysql/ directory there is a logrotate.conf file that contains the following comment : # Configuring /etc/logrotate.d/mysql-server does not yet work. which is the logrotate config for mysql on that machine. I need to rotate those log files much much sooner than they are being rotated now. does anyone have any experience with a similar setup?
View Replies !
Linux Version
I have a need to setup a MYSQL cluster, however, I do not have ANY experience of Linux and you cannot set up the cluster on Windows currently. I learn fairly fast, but would like someone to recomend a version of Linux that would happliy support the MYSQL cluster and also has some good installation instuctions!
View Replies !
Mysql In Linux
I have installed MySQl in linux and its working properly. I wrote an c++ program to connect to mysql database, which is capable of retrieving, deleting the values from database table. The problem i am facing is i am unable to insert values into the table at runtime. Can anyone please help me as to how to write the query?
View Replies !
Mysqli.dll In Linux
We have developed and application using mysqli.dll and the following functions: mysqli_connect() mysqli_query mysqli_result() The platform was: Windows 2003 / IIS 6.0 / PHP 5 / MySQL 5 Now we need to port over the application to Linux - Red Hat Enterprise Server / Apache / PHP 5 / MySQL 5 Does anyone has an idea what to use instead of mysqli.dll in Linux servers.
View Replies !
DML Of On Linux Server
We have MySQL 5 installed on Linux server. If I defined a table and fields in mixed cases, the table name will be stored in lower case, how about the fields? In the case of SELECT, UPDATE or other DML, do I need to use lower case for the table name and field names? Or do they matter?
View Replies !
Db Migration From Linux To Xp Sp2
db migration from linux to xp sp2 -- can't read I want reinstall my bbs program from fedora 3 to xp sp2 apm. The apm version is apache 2.0.54,php 4.3.11 mysql 4.1.11.(linux and xp) And backup the data and restore on xp machine. ( I tried db copy) The problem is I can't log in my bbs program with migrated ids. But, i made another id and tried to log in, this worked. At phpmyqadmin, I can see the whole records including new id. But bbs program could not read the other migrated records.
View Replies !
Windows Vs Linux
We currently run our MySQL on linux. Could someone advise me on the watch outs on moving MySQL to windows and also if there is any performance loss as a result?
View Replies !
Install
I have mysql installed and have two problems/questions: 1. When I go to start up mysql I receive the following: error 2002 (hy000): can't connect to local mysql server through socket 'tmp/mysql.sock' I have been searching the net for help but haven't found the answer. 2. I want to have mysql start on start up - do I have place a command in /etc/rc.local? If so what? 3. Simiarl to #2, but when I want to start mysql, I have to go to the directy /usr/local/mysql/bin and start mysql that way. I know there is a way to just make it so you can type the mysql command anywhere and logged into mysql
View Replies !
How To Install?
This question will most likely seem unintelligent to you, but here's the basics: I'm doing web design for an organization, I want a mysql database on their server, I have access to this server via ftp, I know the server is Apache... How on earth do I install mysql on this server so I can start designing a database? I've tried desperately to find a simple solution, but every resource I find is too complex... can anyone explain in simple terms, or perhaps point to a very beginner tutorial on how to get started? Can I even do this myself, or do the people who run the server have to install one for me?
View Replies !
Install 3.23 On Mac OS X
The manual gives instructions for 4.x, but I want to use my Mac as a testing environment running the same version as my server, which is running 3.23.53. I'm running OS X 10.3.8 on an eMac, which is still pretty close to the factory install. I'm currently using MySQL with PHP on the server, but I just don't know how to get it running on my Mac. I'm a newbie to Unix, so I don't even know how to get the "shell>" prompt on the Terminal, which is where most instructions begin.
View Replies !
New Install
New install on Windows, MySQL version 4.00.x, i got through a few obstacles, but I'm stuck on this error: "041012 0:16:33 Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist" Where do I go from here?
View Replies !
First Install
I'm trying to install mysql on my linux box for the very first time and can't seem to get it going. I downloaded the mysql app to a /downloads folder i created on the / of the linux box. I then right clicked what i'm thinking is the setup icon and clicked install and it appeared to install the files. Yet when I navigate to the /var/lib directory I don't see the mysqql files. I'm thinking I may have messed up by creating and downloading to this directory. Can someone help me out on this or point me to a well documented source?
View Replies !
MySQL On Redhat Linux
To make a long story short, let me say I had MySQL working on Windows 98 and everything was fine. Well, I took the big leap and removed all traces of Windows and Microsoft from the computer. (hooray!) Once I had Linux running OK, I downloaded and installed MySQL using an RPM package. I guess the server is running (it says it is every time the computer starts and it stops successfully every time the computer shuts down) however, I cannot figure out how to get the MySQL prompt. I've searched the entire hard drive for MySQL, mysql, MySQL*, mysql* and probably some others, too. The only thing I found was a shell script called mysql that starts or stops the server if I am logged in to Linux as root. I cannot figure out how to start the interactive program that allows me to make select statements, inserts, updates, etc. I'm wondering about some things: Did I download and install the wrong thing? Am I just not looking for the correct thing? Did I install it incorrectly?
View Replies !
Mysql On Linux-gui Interface
Is there a GUI interface that is easy to install to manage MySQL on linux? I'm trying add a user account and password to the db server but I'm not having any luck from the command prompt.I'm trying to setup the nexus discussion software.
View Replies !
Linux Korn Shell 93
I have several korn shell scripts I use with a MySQL database on the same server (Solaris). I am moving to a Linux environment where the MySQL database is on another server. I would like to convert the database connection code to connect to the database on another Linux server. I see alot of information on Perl DBI CLI and PHP DBI CLI but cannot find any examples of Korn Shell connecting to a database on another server.Is there a way to accomplish a network connection to a MySQL database from Korn Shell?
View Replies !
MYSQL Server In Linux
I have a SQL server on a Linux Fedora machine and I try to use a GUI to connect to database I used different GUI like "Toad for MySQL" in connection page I put Linux IP address as "Server host" and username/password I keep getting error: Error No. 2003 Can't connect to MySQL server on '192.168.0.121' (10061) My question is: Do I need a client installation or configuration on Windows machine?
View Replies !
Installing MySQL RPM On Linux
I am trying to install MySQL with this command: rpm -ivh MySQL-server-4.0.13-0.i386.rpm I get bunch of errors regarding conflicts with the existing installation (files in /usr/share/mysql/.....) 1. Originaly mySQL was isntalled with Linux 7 install 2. I can't un-install mySQL via Linux Add/Remove program, I get an error stating sthat shared library option must be selected (it's is selected) 3. I have deleted /usr/share/mysql directly, but still have a problem.
View Replies !
MySQL, Linux, Ia32, >4GB RAM
I wonder if anybody here is using MySQL (3.23.56?) on a linux/intel ia32 (e.g., Xeon) with more than 4 GB RAM? Did you find a performance enhancement? With PAE mode on? How does this affect MySQL - being a multithreaded process, is there any benefit in having all that extra memory as anything other than a big disk cache?
View Replies !
Benchmark Differences: Mac OS X - Linux
I recently ran the MySQL benchmark suite on a Dual 1 GHz G4 running Mac OS X Server 10.2.8, and an 800 MHz Intel machine running SuSE Linux 8.0. Both installations used the same my.cnf file. The results are comparable in all benchmarks except one: the 'insert'. In that one, the Mac is more than twice as slow. Below are the benchmark results for boch machines, and the my.cnf I used. I was wondering if there is something I can do, configuration-wise, to do something about those very slow 'inserts' (and 'updates') on the Mac? Thanks in advance for any insight, Jan Pieter Kunst Benchmark results: Dual 1GHz G4/Mac OS X Client 10.2/MySQL 3.23.57: =============================================== alter-table: Total time: 186 wallclock secs ATIS: Total time: 37 wallclock secs big-tables: Total time: 78 wallclock secs connect: Total time: 57 wallclock secs create: Total time: 118 wallclock secs insert: Total time: 6811 wallclock secs select: Total time: 1340 wallclock secs wisconsin: Total time: 21 wallclock secs .... snip ... insert 137.00 insert_duplicates 23.00 insert_key 3099.00 insert_many_fields 10.00 insert_select_1_key 4.00 insert_select_2_keys 6.00 .... snip ... update_big 93.00 update_of_key 180.00 update_of_key_big 29.00 update_of_primary_key_many_keys 478.00 update_with_key 228.00 update_with_key_prefix 22.00 800 Mhz Intel/SuSE Linux 8.0/MySQL 3.23.57: =========================================== alter-table: Total time: 230 wallclock secs ATIS: Total time: 36 wallclock secs big-tables: Total time: 32 wallclock secs connect: Total time: 89 wallclock secs create: Total time: 90 wallclock secs insert: Total time: 2895 wallclock secs select: Total time: 1502 wallclock secs wisconsin: Total time: 20 wallclock secs .... snip .... insert 190.00 insert_duplicates 39.00 insert_key 140.00 insert_many_fields 10.00 insert_select_1_key 5.00 insert_select_2_keys 7.00 .... snip .... update_big 33.00 update_of_key 35.00 update_of_key_big 22.00 update_of_primary_key_many_keys 28.00 update_with_key 178.00 update_with_key_prefix 44.00 These are hopefully relevant parts of the my.cnf I used: [mysqld] skip-locking set-variable = key_buffer=64M set-variable = max_allowed_packet=1M set-variable = table_cache=256 set-variable = sort_buffer=4M set-variable = net_buffer_length=8K set-variable = record_buffer=1M set-variable = thread_cache=8 set-variable = myisam_sort_buffer_size=8M log-bin server-id = 1 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M
View Replies !
Using Database In Windows By Linux
I am hosting an intranet on a machine with dual boot in both win98 and RH9 Linux. the intranet was first set up and running in win98. I have a mysql database in the win98 . The win98 partition is mounted in Linux and is accessible. I am duplicating the intranet in Linux. the HTML pages are accessing from the win98 partition. Is there a way to use the database as such by the intranet in the Linux.
View Replies !
Connection To MySQL On Linux
I am New to Linux PHP apache and MySQL (following the Book, Begining.PHP, Apache, MySQL Web Development). Got as far as chapter 3 without too many problems. Well no I'm stuck. I get the following error Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /usr/local/apache2/test/createmovie.php on line 4 Database connection error, check your server connection when then following piece of code is executed $connect = mysql_connect("localhost", "mysql", "mysql" ) or die ("Database connection error, check your server connection" ); I'm, A bit lost about which file the path is stored.Has anyone came across this similar problem and found a fix for it?
View Replies !
Create Dsn On Linux Machine
i am raghvendra. i am working on linux. i am using a php4 with apache 2 on linux machine. i want to create a dsn on linux machine. but i donot know how can i do this. my database is on remote windows machine.
View Replies !
User Mysql On Linux
I´m using Red hat Enterprice WS 3, when I install mysql (version 4.1.7) on linux, everything ok, but when I type # mysql error ocur: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
View Replies !
|
TRACKER
