Jump to content
xisto Community

vhortex

Members
  • Content Count

    621
  • Joined

  • Last visited

  • Days Won

    1

Posts posted by vhortex


  1. I did stop the MySQL service before I uninstall it.

    After it was uninstalled, MySQL service was deleted as well.

     

    but taht error message still keep coming up.

     

    So, I opened regedit, and deleted all entries which contain the word "MySql".

     

    then, it works.

     

    Why dose the MySQL uninstaller not just delete those entries.

    are those entries keeped for any purpose?

    <{POST_SNAPBACK}>


    If you are on XP with NTFS partitions and service pack 2, things wont work as they used to.

     

    Everything that needs to be uninstalled must have the ownership set to your current logon account and all of the related files (exes and registry) must not be in use or running before they can be deleted or overwritten.

     

    If you are in NTFS system, try to create 2 accounts in windows. One is an admin and one is an ordinary user. Install Microsoft office using the admin account and logoff.

     

    Logon using the normal account and use "microsoft photo editor" which is the standard photo editor of MSoffice. You will then notice that you cannot open any files using that program since the registry is locked to the admin account.

     

    ***********

     

    hope this helps.


  2. Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 48

     

    Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 330

     

    Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/vhosts/rohit.bizhat.com/forums/db/mysql4.php on line 331

    phpBB : Critical Error

     

    Could not connect to the database

    <{POST_SNAPBACK}>


    This is a server side error which only the webserver admin can correct.

     

    mySQL servers have limited connections capability as of version 3.x, the max user can be atmost 100 connections.. at mySQL version 4.x, the connection goes up to 500 - 1000 connections as far as the last release I have on my pc.

     

    Connection limit is base on the maximum current connections the server can handle.

     

    Most of the time, mySQL server can process each query at a microsecond speed but there arise the question why some webservers encounter the error above.

     

    1. First is that when mySQL server is accessed on the internet, there are countless of visitor that can access the website at any given time giving way to hammering and filling up all the connection slots to the servers.

     

    2. Shared webserver hostings with shared connection poll will also trigger this event since assuming that there are 100 hosted sites sharing the same mySQL server with the same connection limit. If all 100 websites have 1 visitor at the exact time and 1 new visitor visits the same site at the same exact time, one of them will get that socket error if the max connection limit is 100.

     

    3. There are times that we make scripts that connect to the database that are malformed. Malformed since they lack the full cycle of connection to the server. The full cycle is

     

    a) locate server

    :P connect and open connection

    c) process query

    d) disconnect and close connections

     

    sometimes, we forget the closing part or we have a database connection command that are unreachable to the scripts.

     

    Unclose connections stayed up in the server. For us the connection is finished but for the server, it will dutifully waits for the the client softwares or programs to send their disconnect commands.

     

    For every unclose connection, a connection slot is taken and on default installation, the autotimeout of the database sometimes is set to 45mins.

     

     

    --------------

     

    Hope i solve the problem, the best solution is to contact the server admin for some assistance since mostly the settings are beyond your control.

     

    geez, this seems so long, maybe I should put this one as a tutorial :P


  3. You're right.. Why bother reinventing the wheel when we can come up with our own anti-grav devices :P

    <{POST_SNAPBACK}>


    Three thumbs up on that.

     

    I do bore sometimes on the "standard" tool sets. The software tools I need always seems to lack something.

     

    Perhaps this will be really a great way to start an open source like environment where everybody contributes and puts ideas together.

     

    I wish for this success and I will wait for the developement and for the time to kick in the project.

     

    :P


  4. Im not sure if SuSE can do this automatically i know mandrake doesl)... anyone else know ???

     

    boot the suse install cd, and only go as far as the partiton settings.

    is there any options to re-size the windows partiton ???

     

    if so, do it

     

    if not, then abort the install.

     

    you need to resize (shrink) your windowsXP partiton before booting the suse install cd.

     

    You can either do this with partiton magic for windowsXP,

    or with linux-ntfs for linux. http://www.linux-ntfs.org/

     

    partition magic is not free, (dont know if you can get a trial version)

     

    if not, then boot knoppix, and use linux-ntfs or qtparted to resize.

    <{POST_SNAPBACK}>


    this can be done with any linux OS..

     

    first install the windows OS since microsoft has a very high reputation in ruining a linux or unix systems boot loader.

     

    aftet the windows OS system is installed [which is the case for you] you can then install the linux or unix OS..

     

    NOTE: dont use OEM versions since they tend to search for specific chips on the pcs. red hat linux is a good smple of non OEM linux.

     

    if your harddisk have partitions then good, use the remaining partition for the linux / unix install.

     

    if not follow the suggestion above regarding partition magic..

     

    aftet the partition have been setp up properly you can install the linux / unix OS and they all have a multi boot software which is GRub for red hat linux.

     

    I won explain how to install the linux/unix OS since they all have different ways of instalation.


  5. If you are going to focus on connecting only to SQL based dataservers then there is already an available import/export tool and a sched backup module for paid version.

    If you have time then check this website https://www.webyog.com/

    That website is the official website of SQLYog which is an alternative way of connecting to SQL based database servers. It also supports up to mySQL 5 and all of the functionality of PHPmyadmin plus a lot more..

    There is a saying that we dont need to reinvent the wheel. :rolleyes:

    BUT.. for any other reason that you still want to continue your project.. count me in, I can code in C and Java and I can declare myself as proficient in MYSQL..

    I do believe that there are always a better way around some stuffs... :)


  6. I am using Mysql 4.x and I want to upgrade to mysql5...

    anyways Thanks...

    <{POST_SNAPBACK}>


    :rolleyes: On what kind of site are you going to use your mySQL server. I do have one on my own PC for testing with my ERP program made of pure JAVA..

     

    As of now, I can only recommend the 4.x version since mySQL version 5 is still buggy and not good if you are going to expose the server to the public..

     

    example:.. broacasting it to the net as backend for datab driven websites.

     

    there are also some issues regarding the installer modules both in linux and windows and the safest way I can recommend is to install it manually.

     

    Last time I check the site, they are testing the integrity of the new version..

×
×
  • Create New...

Important Information

Terms of Use | Privacy Policy | Guidelines | We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.