Enabling/Disabling InnoDB With Default Mysql Installation.
If you install mysql and find innodb table type is not available,
follow these steps.
find my.cnf file. usually my.cnf file resides in "mysql/bin" folder.
Then search for "skip-innodb", if you find the line then comment it as
"#skip-innodb", then retart you mysql daemon.
Thats it
To disable, uncomment "skip-innodb" or start mysql daemon with
following command
mysql --skip-innodb
thats it.
View Complete Forum Thread with Replies
Related Forum Messages:
Disabling / Enabling Form Fields
ive got a pretty big form, however depending on whether they're male or female i want the user to fill in certain fields. If they select they're female, i want to disable all the form fields for 'male' using php.
View Replies !
How To Overwrite Default Php Installation
On my linux system php seems to have been installed by default. When I type: "which php" it tells me /usr/bin/php I installed php and it has put an executable in the /usr/local/bin/php "which php" still says /usr/bin/php "whereis php" php: /etc/php.ini /usr/bin/php /usr/local/bin/php /usr/local/lib/php /usr/local/lib/php.ini /usr/local/lib/php -v shows the new version but php -v shows the old version. How can I correct this problem? I want to run the command php -v and it shows the newest version. I have already tried removing /etc/php.ini /usr/bin/php
View Replies !
InnoDB Vs. MyIsam Mysql Tables
I'm using php with mysql. I have some very large MyIsam tables that are constantly being updated and get LOCKED quite a bit. I was told to change my table type to InnoDB. After I made the change I was not getting any tables locked, but the functionality of the tables doesn't seem to be quite as fast, and I am having a little trouble with a php script that joins the InnoDB table with a MyIsam table. I have indexes on the InnoDB table if this means anything. Can someone tell me the difference between the two types of tables.
View Replies !
[ot] Listing Foreign Keys In MySQL On InnoDB
I use mysql 5 with innodb engine. When I create a table like: create table tbltest( testid int(10) UNSIGNED NOT NULL auto_increment, artid int(10) UNSIGNED NOT NULL REFERENCES tblart.artid, PRIMARY KEY (testid) ) ENGINE=InnoDB; Works fine. If I insert a value in artid that doesn't exist in tblart, mysql produces an error as it should do. Now if I want to find out about the tablestructure, like this: SHOW CREATE TABLE tbltest; mysql just shows the create table syntax, BUT without the FK-constraint. When looking through the documentation I only found SHOW TRIGGERS, but that also doesn't list the FKs. I must be missing something completely in the docs. :-/ How can I ask mysql which Foriegn Keys it has?
View Replies !
MySql InnoDB Transactions, Exception Handling
If I start a db transaction, using a InnoDB table in MySql, and want to ensure that at the end I either commit or rollback, what's the cleanest way I can implement that in PHP? Pseudo code: start_transaction() try { do stuff commit(); } catch (Exception) { rollback(); } Can this be done in PHP like this? I want to ensure that any error at any point doesn't leave any allocated resource around, or open transactions around.
View Replies !
Problem On Default Value : : MySQL
Problem on default value : : MySQL I am facing problem in this line `datetime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, when I tried to crate a new table in MySQL(version 3.23.47-nt)
View Replies !
Default Value To Insert Into MySQL
What should I insert as the default value if a form field is blank? My fields don't currently accept null. if($_POST['height']) { // error checking $height = $_POST['height']; } else { $height = ''; } Should $height be equal to '', NULL, or maybe 'NULL'? I'm thinking 'NULL' incase I or someone else decides to change the field to accept null?
View Replies !
MySQL Installation
i am trying to install mySQL5 server for a computer, but it's hang when it trying to apply security settings. Sometimes, it will show a message which tell the user to open the firewall port for mySQL, but after i open the port, it's still hang, so may i know the reason why it will hang? if untick the modify security settings, then there is no problem, cos it didn't apply security settings. besides that, may i know how to uninstall the mySQL then install again? is it just remove the program?
View Replies !
Installation And Mysql
My attempt to install php and mysql to my computer failed. There are errors with both installations. I believe the problem is with my computer or the Windows XP in it. My computer is an old and cheap laptop Dell. It has been in trouble for a long time. I've been learning php on my web site for some time, and wonder whether or not I can do mysql on web site without installing the software to computer.
View Replies !
MYSQL: How To Set A User's Default Database?
Is it possible to set a user's default database for MySQL database? Instead of having an additional line of command, i.e: mysql> use database <database_name> Perhaps there are parameters I can set up a default database for a user when she log on to mysql.
View Replies !
Default Date In Mysql Table
I had a table with a DATE column with default value 0000-00-00, but it is optional that is user can enter a date or just leave it blank. How do I do to ensure that: 1. the date inserted will be 0000-00-00 and not 1970-01-01 2. when the table is updated and IF there is no changes to the DATE column, it will still holds the value 0000-00-00.
View Replies !
Default MySQL Administration Credentials
I installed MySQL administor to administrate mySQL but it seems i need a username and password to connect. I do not remember specifying a username and password during installation. I was thinking maybe there might be a default username and password.
View Replies !
Apache/mysql/PHP Installation
So i installed xampp package, and that works if i do not touch anything. If i change doc_root in Apache configuration file, localhost points to the location and html files execute normally but php doesnt. Can anyone tell me what else must i setup except Apache conf file so i can execute PHP files in directory i create somwhere on the disk? How can i change the default directory in which php scripts are executed?
View Replies !
Mysql - DEFAULT '' Defined Yet NULL Inserted
My database was inserting NULL for empty strings so I changed the field definition with this query: ALTER TABLE `myTable` CHANGE `myUrl` `myUrl` VARCHAR( 255 ) NOT NULL DEFAULT '' No error was reported following the query and yet I still get NULLs on insertions.
View Replies !
MySQL Datetime Field Default Now() Fails
I have a mySQL database table with a column field datatype of datetime that I set up in the original create table statement like this: create table nnet_usermetadata ( .... nnet_record_entered datetime default 'now()' ) However, upon execution, each time a record is entered into nnet_usermetadata the results are: 00-00-0000 00:00:00 Is there a way I can always ensure that the current date and time are always entered into the datetime field?
View Replies !
Installation (MySQL, Apache, Perl, And PHP)
I just installed MySQL, Apache, Perl, and PHP, and am having some issues with PHP. I am not really sure if it is loaded correctly. When I execute apachectl restart, it responds that the server is restarted, but a test html page with the tag <phpinfo ( )?> does not produce any specific output. Is this a correct test page, or how else can I test that PHP is functioning as a Apache DSO?
View Replies !
MySQL/Windows Installation Question...
Just upgraded MySQL on my development machine to 4.1 and get the familiar error "Client does not support authentication protocol...". A bit of Googling learns this is expected behaviour and all clients in use should be instructed to use the new protocol (including PHP). However, on none of the hosts used for hosting client sites this has ever been a problem yet (most still use 3.23...) and I don't want to be obliged to change things everytime I move a finished site from my machine to the clients host, so I prefer to stick with using the old password. This is possible: the documentation tells me to just start the service with 'mysqld --old-passwords' as option. However, as per the registry, MySQL starts automatically as a service when windoze starts. Without this option. Now every restart of the machine I can stop the freshly started mysqld service and start it again with the --old-passwords option but it should be possible to do this leaving the appropriate info in the registry. Anybody 'been there, done that'? Where to put what in the registry with this effect?
View Replies !
Installation Of Php/apache/mysql On Win98
I'm using an old computer - Win 98. I'd like to install php/apache/mySql on it but there are many versions and some do not recommend installing on Win98. If somebody could point me in the right directions about which versions of apache, mySql and PHp - or if there is a package suitable for Win98 that would be great.
View Replies !
PHP5 Installation With MySQL, Windows 2000
Why I still have "undefined function error" messages? I included path c:php to my windows env. Edited php.ini file: include directory value. removed comment mark from extension=php_mysql.dll copied libmysql.dll to system32 directory Apache2 runs fine. I can run phpinfo.php I can create a database into the MySQL.
View Replies !
Fedora 4.0- PHP 5 - MYSql 5 -Apache With 64 Bit Installation Help...[URGENT]
Can anyone help in installation of Fedora 4.0 , PHP 5 and MYSql 5 with Apache webserver I want to install 64 bit version of all because I bought new PC with 64 bit supporting. Please provide me help where I can get step by step information about installation of all above and if necessary give download link also. I tried myself lot but not successfull. I have 64bit fedora 4.0 which is installed from fedora site. Guide me soon if possible I need to start project in PHP 5 and MySql 5.
View Replies !
Call To Undefined Function - MySQL Installation Faulty?
I encounter an error when trying to connect to MySQL database from PHP. I have checked the web server log. It contains following error: [Tue Feb 13 10:54:57 2007] [error] [client 172.16.16.50] PHP Fatal error: Call to undefined function mysql_connect() in C:Program FilesApache Software FoundationApache2.2htdocsindex.php on line 5, referer: http://172.16.16.50/ is my MySQL installation faulty? or is it a PHP problem?
View Replies !
Apply InnoDB
I had found an application which need InnoDB,I am not sure what is it.However it doesn't support by PHP/MYSQL,I am using xampp as localhost.May somebody help me to work it out?
View Replies !
Information On InnoDB
I'm very curious about InnoDB. Does anyone here use it? Can it be used instead of MyISAM (i.e. I am not dealing with large tables in need of high efficiency)? I am using relational schemes more and more and the whole cascading delete interests me. Anyways, I am all ears to anything anyone has to say about the subject. (Also I noticed that my hosting provider does not allow creation of InnoDB. Is that common?)
View Replies !
MyISAM Vs InnoDB
I'm just curious to know the difference between MyISAM and InnoDB. Are there any difference between these two storage engine, performance wise?
View Replies !
PhpMyAdmin Installation - Thorough Installation Guide.
I am trying to install phpMyAdmin-2.6.3-pl1 on my machine because I am familiar with working with it itself, but not installing it. I have Apache 2.0.54, php 4.4.0, mysql 4.1.14 running on a Win XP Home machine. Like I said, I've never installed phpMyAdmin before and I've looked at the documentation and I can kinda make out what it says, but I'd rather try to find a very thorough installation guide.
View Replies !
Database Stores Default Number Everytime, But I Havent Set A Default Number??
Im having some problems with my database. Everytime i store a number which is longer than 10 numbers the script or database puts this number into the database: 2147483647. Its does this everytime no mather how i write the numbers and nomather how long the number is, it just needs to be over 10. I have set any default value in the database and to be sure i havent i tried deleting the table, but same thing happends again???
View Replies !
InnoDB Autocommit And Locks
I have 2 questions regarding InnoDB tables: 1. In the MySQL manual, it states that "MySQL begins each client connection with autocommit mode enabled by default. When autocommit is enabled, MySQL does a commit after each SQL statement if that statement did not return an error." Does using BEGIN override this behavior? In other words, with autocommit on, does BEGIN open up a new transaction and stop committing until an explicit COMMIT command? Or do I need to turn autocommit off before multi-query transactions? 2. I have been reading the examples for LOCK IN SHARE MODE and FOR UPDATE in the manual, but I am still confused as to when I should use one as opposed to the other. I have gone through tutorials but many just use the same examples as the manual. I'm sure I'm just missing something small, but if someone could give a simple example of the difference between the two, that would be very helpful as the difference to me seems very suttle.
View Replies !
Unrecoverable InnoDB Crash
We have had a database crash and are not able to recover the data that is stored in the InnoDB tables. Our website was hosted on a temporary server for a few months. The backup procedure did not work propperly and we had a server crash. The disk was full due to big dump files. As far as I know a cached file was removed that was related to MySQL to free up disk space. I presume this file was not needed in any way and it could be removed. After this "crash", MySQL would not restart. But after the second attempt it did. All MyIsam tables are working fine, but the InnoDB tables are unreadable. The only thing that I can see is that PhpMyAdmin returns "Table in use" for each of the InnoDB tables. We must make the decision between restoring an (very) old backup or keep on trying to find a way to recover the data. Is there anyone who can give me some helpfull tips on recovering the data from the (locked?) InnoDB tables?
View Replies !
Text Matching On InnoDB Table
So INNODB tables don't support full-text search indexes in MySQL so I can't use this: Code: select * from my_table where match(text_field_1) against('search keywords') Am I now forced to massage my search words into a big fat LIKE clause with wildcards or is there some other way? Also, I was a bit frustrated with full text search failing to match the keyword 'prod' with 'productions' or 'products'. Only complete word matches were taken into account.
View Replies !
Deleted Innodb Tables In Linux
I had some innodb tables and i deleted the files representing them from the command line in linux. so you'd think there would be no problem but not so, I try to create those tables again and mysql throws back an error "cannot create tablename.frm" or "table already exists". Anyway to repair the innodb data table?
View Replies !
FULLTEXT & InnoDB, And Backing Up Database
Anyway, I have 3 questions: 1) I put together a database with 17 tables all of the InnoDB type. This is my first time doing this, so I've been learning as I go. Currently, I wanted to make a couple of fields searchable. I tried to make them FULLTEXT indices, but found that it's not allowed with InnoDB tables. I couldn't easily fidn a way to do searches with InnoDB. Is this something that can be done. If so, how? Code:
View Replies !
Strange Behavior With Phpmyadmin And Innodb Tables
I recently converted all my existing MyISAM tables to InnoDB tables through phpmyadmin. I noticed some strange behavior whenever I would refresh the screen, as phpmyadmin would report different numbers for the cardinality of the primary key (i.e. one minute it would say cardinality 388, then 244 on refresh, then something else), and it would report different values for the number of rows when mousing over the table names on the left menubar. This behavior only seems to exist on tables with a "larger" number of rows, and by larger I only mean ~100 or more rows (tables with fewer rows always report the correct number of rows). Whenever I do a SELECT *, I get the correct number of rows returned, so I know they are actually there.
View Replies !
Disabling SOAP PHP 5.2
How do I go about disabling SOAP extensions with php 5.2? Is there a simple edit to php.ini? I am trying to use NuSoap and am getting a conflict problem.
View Replies !
Disabling Html
I have a guestbook page and I've added a captcha to it but there's been at least 1 instance where someone took the time to send some spam anyway.the comment was "nice site" with a link - is there a way I can stop someone from putting html in the textarea?
View Replies !
Disabling Enter Key
I have some forms with several fields that I have setup with a "Submit" button and a "Reset" button. Currently these forms can be submitted using either the "Submit" button or the "Enter" key. I did not intend for these forms to be sent when the enter key is pressed and this function is proving to be troublesome. I get several forms that are incomplete because the enter key was pressed in error. Is there a way to prevent the enter key from sending the form? Ideally the cursor should move to the next field when the enter key is pressed. I would like only the "Submit" button to send the form. Code:
View Replies !
Disabling Links Etc.
I am designing a puzzle hunt with a friend. The basic idea is you solve puzzles of various types (word puzzles, logic puzzles, etc) in order to access more puzzles. Well, I was wondering just how to get that to work, assuming it can be done. Specifically, what I would *like* to be able to do is to set up the page such that a user must be logged in to access any puzzles (solvers will be working in teams). While logged in, I want puzzles to have one of three states: solved, available, and unavailable. Code:
View Replies !
Disabling The Back Button
I have a form that is to be filled. The summit button call a php script that populates a database. Is there a way to make sure that if someone click on the back button on the browser they do not get a chance to send the same form again.
View Replies !
Disabling The REFRESH BUTTON?
I have a page: customize.php The page has two submit buttons using CSS to give them an image. <input type="submit" name="AddToCart" src="../images/customize_addcart.jpg" class="AddToCart" value="" alt="Add To Cart"> <input name="PriceUpdate" type="submit" class="PriceUpdate" value="" src="../images/customize_updateprice.jpg" alt="Add To Cart" /> At the top of the page. I have an IF STATEMENT that will determine which BUTTON has been clicked on. If the "AddToCart" button has been clicked > The information is sent to the Shopping cart and and page is redirected to cart.php using "header function" When the user clicks on the "PriceUpdate" button the page will recalculate the total price based on the selections from the POST variable... PROBLEM IS: Once the user clicks the "PriceUpdate" button - if they click on the refresh button on their browser window. A warning ALWAYS comes up saying: " The page can not be refreshed without resending the information. Click Retry to send the information again, or click Cancel to return to the page you were trying to view. " How can I make is so this message will not occur -OR- Bypass this message -OR- Just make it so that the Refresh button on the browser does not do anything if clicked.
View Replies !
Disabling Oracle Triggers With PHP
I'm using the PEAR database abstraction (MDB2) to access Oracle 9i. The PHP application is interacting with Oracle to execute Oracle Procedures. In one procedure the logic includes disabling triggers before deleting data from the table. The delete statement works, but the alter command to disable the trigger fails. THe procedure works if you call it outside of PHP. Anyone ever have problems with PHP call ALTER commands and/or disabling triggers?
View Replies !
Disabling Oracle Warning?
i have a form called login.html where i enter my username and password to connect to my oracle db. I click the submit button and it will go to my memberlogin.php. If i have entered my details correctly a form should appear to enter data in my text field. If however i have not entered it correctly it should say "Sorry could not connect to database". I have a few question needing asking please: If i have not entered my details correctly i want my error message to appear. However, when i enter it incorrrectly i get the message: Code:
View Replies !
Disabling Field Input
I'm trying to use PHP to conditionally disable a field within a form. It's not working out for me, and I don't know why. I have a field called "customizable" which is a Y or N radio box (defaulting to N). The next field is "character_limit". If "customizable" is set to N, I want this field grayed out (disabled?) But if someone checks the "Y" box for "customizable", I want this field to be activated. Below is the code I tried, showing both fields. (Note that both fields are contained within the same form): Code:
View Replies !
Disabling Emailing Function
Its prebuilt webcard site that i want to develop where instead of emailing the person (recipient) a webcard you(the sender) gets the code that usually is emailed to recipient to display and NOT emailed on the next page. Therefore the sender can give their friend a secret code to view the message. SO far I managed to delete the recipient fields as it is not neccesary. So far I'm doing good, now its just hot to modify the index.php where instead of sending an email you press the get code submit button it then displays the emailed results on the next page.
View Replies !
Disabling The Display Of Any Code
I haven't created my code for comments, but I was worried about someone maliciously trying to inject code through a comment box. I was wondering how one would go about disabling the display of any code.
View Replies !
Disabling Showing Of Session Id
I'm showing the url an user visited via an email. I'm storing the address of the page in a session variable. But whenever I'm trying to show the page url it's showing the url with the session id as follows: /product/product.htm?PHPSESSID=771df9daffa8f58d7e87f2a90c9b5064 The code doesn't contain anything that should echo the id. I don't want the id in my url and if any page has the id alongwith the url, I'd like to remove it. Is there any code snippet which will enable me to do the same?
View Replies !
Disabling The Built-in POST Handler
I need to handle very large file uploads and push the data into a socket. Having php to write everything to a temporary file, then reading it again inside the script and pushing it into the socket is very inefficient and imposes size limitations to the uploaded files (which may reach GB in size)....
View Replies !
|
TRACKER
