MYSQL :: What Is A Config File ?

Configure A 'config.inc.php' File (was "phpMyAdmin")
This is my first go at creating a PHP/MYSQL website so please could someone help me?

Basically i'm using phpMyAdmin to manage my MYSQL database on my webserver. However you have to configure a 'config.inc.php' file before you can use the system. Can anyone talk me through what settings I need to include in this config file to make it secure?

Mainly i'm worried about the differences between 'cookie', 'conifg' and 'http' modes. What do they mean (i've tried reading the FAQ's but they don't help much for newbee's!)? Which one should I use?

I hope someone can just give me some clear advice on what I need to do to get my database online and relatively secure.

PhpMyAdmin Config.inc.php
I must have a wrong setting in the config file because when i view a database i get the Notice "Notice: Undefined index:... i just can't find where the error is. Everything else works great though.

MySQL Config
I have installed MySQL on Windows98se twice under different paths, and then
deleted the second installation. When i run MySQL as usual using the line
"C:Program Files
uspheremysqlinmysqld-opt.exe" , i get the following
error msg:

C:Program Files
uspheremysqlinmysqld-opt.exe: Fatal error: Can't find
messagefile 'C:Program Files
usphere2mysqlshareenglisherrmsg.sys'

notice that it runs from "nusphere" but tries to find the errmsg.sys file
under the other folder "nuspehere2" which i have deleted.

I tried looking for a config file so that i can force MySQL to look in the
proper "nusphere" path, but i could not find any. I have also tried to look
for an entry in the registry but came out with nothing aswell.

Have I missed something? Any ideas on how to solve this?

MySQL Config
What config modification would give me a good speed increase for a site that has a lot of online users on forums (so a lot of DB change)

Mysql Config
i have a mysql php script on www.rizzler.se/sizeofmysql.php that checks the size of my sql, as you can se on the link above nothing is shown on the page thou. BUT as i upload the EXACT same script to another server that has the same settings as mine. same mysql database name and password etc http://lunarplejs.brinkster.net/sizeofmysql.php

there it works but not on my server and i wonder why? my server say that mysql is running. i can connect to it with mysql query browser and so on, is this cause of my PHP.ini settings ?

Installation And Config Of MYSQL
Installed Mysql in Redhat 9.0 workstation. I have installed MYSQL,Appache,PHP.

PHP,Appache installation is fine and intergration is also working fine. I have installed and configured MYSQL

Problem : I cannot log into MYSQL database either from root or user.(local host)

The error is 2002: unable to connect to local host thru socket "varlibmysoc" but cannot locate the mysql.sock in /tmp And the service is sqldb is also not working and cannot locate in services.

MySQL Config Error
I have been tasked to create a CMS for a website, however first I must install it locally to my laptop.

I have chosen Joomla! as my CMS, and I understand that in order to run that I must first install Apache, MySQL, and PHP (in that order).

Apache installed fine, as did MySQL (the most recent version), however, it will not let me configure it or run the config tool at the end of the installation, citing the message:
"the side-by-side configuration is incorrect."

Does anybody have any idea why this keeps happening and what I can do to resolve it?

MySQL Config Not Running
i'm trying to set up MySQL with IIS 7.0 on Windows Vista Home Premium. After you install MySQL, there's a check box to launch the config app.

if i leave it checked, the app does not load. if i try to run the app by double-clicking its icon it gives me an error saying, "The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more detail." I cannot find the application event log, though.

Server Instance Config
After installing MySQL 4.1.13a, Server Instance Config Wizard runs. At the end of the wizard it wants to execute, to finalize the configuration. Though once it gets to the point of executing the Service. It fails.

MySql Username / Password And Config
Firstly USERNAME AND PASSWORD? You define them where? Edit them where?

http://localhost will not work on my computer, how can I make MySql run from 127.0.0.1 ?

Config Mysql To Acces It Via Internet
i want to know how to configure mysql to access it by internet. i am behind a router and redirect the 3306 port here is my my.ini: Code:

Problems Running With Instance Config Wizard
I can't seem to run the Instance Config Wizard for MySQL 5.0 on my computer. I am running windows Vista and each time I attempt to run the Wizard it responds with a dialog box:

"The application has failed to start because its side-by-side configuration is incorrect. Please see the application event log for more details."

How do I resolve this issue?

Config Mysql For Huge Data But Single User
IÂ´m new to mysql and want to know how I set up the my.ini for best performance.
IÂ´m running a PC with dual core and 3GB RAM, Windows XP, XAMPP
I want to configure mysql for best performance for a singele user acess.

I just want to do some sql-query on a huge database (25GB) - only one query at once.
At the moment my query nedds about two hours....

How Do I Upload A File To MySQL Database And View That File
I do not know how to upload a file to MySQL database and view the posting file on the webpage. I followed the code on-line that show me how to upload, but when I click "browse" to open my file in local drive and click "upload". Nothing happen ! How can I view it on the web page to make sure it was saved in data base.

Log-error File 'not Found' But This Same File Being Written To?!
I recently put up a message board and I get around 150+ hits a day so far. I've recently had some people sign up with my board but unfortunately, no one seems to be posting (they're just lurking around). I'm currently doing some promotions in the hope that others will post (like giving away a Lord of the Rings poster to all users who has 20 posts or more).

Of course, my board has only been up for less than a month (3 weeks to be exact) so I know I need to be patient but I would appreciate any advice you can give me on how to turn lurkers into posters.

.db.bk File
Need some file help. I had a host create a dump file of a mySQL database for me and the file is a .db file with a .bk extension (database file with a backup extension); i.e. filename.db.bk. I am moving a site to a new server and am used to having a .sql file for the database backup. How do I convert this file to a .sql so I can upload it to the new database?

Log File
I'm running mysql 4.1 with logging enabled. The master server produces a log file which is used for replication. I was wondering if there is a way to make the logfile turn over without stopping the database. Sometimes the file gets rather large and I'd like to turn it over without having to shut down mysql.

Where Is The .MYD File
I installed the MySQL server 5.0 and created a table with the default storage engine in the "test" database. But I cannot find the .MYD and .MYI file in the data directory. Only a .frm file resides there. Where are the .MYD and .MYI files?

What To Do With A Dmp.gz File ?
I've a site hosted at ipower.com and I recently upgraded my vDeck control panel from version 2 to 3 as they suggested.

Before that, I'd an option to backup my databases and they were just a .gz which on extraction gave me all .myd,.myi and .frm for each and every table so as to replace any table or entire DB in my local server.

Now, on clicking download, it gives a dmp.gz, and on extraction a dmp file.
How can I use this file in phpmyadmin or local file system to see the data ?

File Fox
I've been using a document management system called FileFox on a
Windows 95 platform and need to migrate the data from FileFox
(apparently stored in .dat files) to a more current database package
that will run on a Windows XP platform. Has anyone else ever used
FileFox or is there some way to migrate the data from these .dat files?

No Log File
mysql Ver 11.18 Distrib 3.23.52, for pc-linux-gnu (i686)

The doc page on mysql.com says "...start it with the
--log[=file_name]...". When I put --log in the safe_mysqld line and
restart - it doesn't start. Take it out, starts right up.
And I can't tell if logging has any thing to do with /etc/my.cnf

Bottom line of what I'm after - violations of a unique index. That
10,000 inserts worked just fine - don't care - that 5 lines were already
there, yes.

How Do I Fix A .frm File?
I am getting:

Incorrect information in file: './nitewise/newsletters.frm'

Error

SQL-query :

SHOW COLUMNS FROM `newsletters` FROM `nitewise`

MySQL said:

Incorrect information in file: './nitewise/newsletters.frm'

I have tried myisamchk -r newsletters.frm

I get :

- recovering (with sort) MyISAM-table 'newsletters.frm'
Data records: 1
- Fixing index 1

But still get the Incorrect information in file: './nitewise/newsletters.frm'

Can anyone tell me how to repair this file?

A DDL File
Hello, I'm new to this community but have heard nothing but good things about it.
I have a .DDL file that I need to run on mySQL to build a database for me. I was wondering if someone could explain to me how I am to do this, I've looked everywhere for help but have been unable to find out how.

I'm guessing I would do it from the command line client, but am unsure what to do after I'm loged into root.

the file is called "buildDB.DDL" .

My.cnf File
I want to create a database replication and for that i have to work on my.cnf file of my sql. Ihave tried to search this file by using the following command
find / -name my.cnf -print

but it did not give any result. I have mysql 3.23.36 running on FreeBSD 4.3 Version.

About My.ini File
can anybody share your my.ini file with me? I don't know what to write on it....
I copied one from web, but after paste it to my own .ini file, the whole sever shutdown.

and alway comes out with
ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

I tried to type
C:mysqlin>mysqladmin -u root status
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to MySQL server on 'localhost' (10061)'
Check that mysqld is running on localhost and that the port is 3306.
You can check this by doing 'telnet localhost 3306'

C:mysqlin>

Run A .sql File
I know very little about MySQL, enough to get into trouble.

I downloaded a script and the first instruction is to
Quote: Use phpmyadmin to run site.sql against your database
I have phpmyadmin 2.5.1 and have used it before, but have never used a .sql file.

CSV File
I haven't got a clue what I need to be doing at this stage but basically i want to upload content from my excel to my db that is a MySQL db on my server.
BUT, the excel document only has one feild which is names. How do I upload that into my names tables on the server???
And one more was that, I also have the same file in a .txt format, the names are on seprate lines. How would I upload that into the db

##### In O/p File
After running a query the o/p is as

Name Class Address age dob
asd #### asfsfd 35 1712
fre #### hshdh 23 6512
bdh #### jdjdjj 10 2434

Why the values in class reflecting as #### instead of correct values

.sql File
I am pretty new to MySQL and I need to import one sql table into access.
someone has sent me an barcode.sql file. This file has one table with data in it.
I am trying to run this mysql database file on my server but its not working out.
do i need to do some importing first before i can run this database on my server.

Run File.sql
Just found a script I want to mess about with
in the docs to upload, alter, set up database etc
it states -
use phpmyadmin or your mysql interface to run file.sql against your database
im in PhpMyAdmin, now what do I do to run this file against my database

*.sql-file
I have to expand my MySQLDatabase with a new sql-file, but I have no clue how to upload this. I've found tons of information about importing txt-files, but nothing about sql-files. I am using phpMyAdmin 2.7.0
Maybe it's so easy, that there is no need for any documentation?!
Unfortunately I am not really a MySQL expert

A .csv File
can i upload a .csv file to work with mysql?

.sql File
I've written some sql in a file I called create.sql
How do I run this file in MySQL?

The path to it is C:documents and settingsuser
ailsappsprogramcreate.sql

Changes In Cnf File
I have a master and slave. They've been running fine for a few weeks and today I changed the slave's cnf to log updates and enabled the bin logs.
When I restarted mysql, these changes didn't take effect. How can I get them to? Am I missing something?

12 MB Sql File
I have a 12 MB sql file that I want to put on my localhost but it keeps timing out. Any way to fix this

Pdf File In MySql
How do I store 500kb pdf files in mySql?

Import A .sql File
Ok, probably any easy task but not having much luck here. i exported to an .sql file a database from phpmyadmin. now, what i want to do is use that file to recreate the database on my local test machine. i do not have phpmyadmin installed on this system, so am looking for the proper query i can use at mysql command line to run.

6mb MYSQL File
My forum had problem so my idea was, safe it all in a .mysql file and delete it, and upload it later again... but now when i tried to upload it, it says max file size of 2 mb... what to do?

Which One Ini File Is The Correct One ?
I have install mysql in my windows machine.The confusion part here is that I find there 7 different ini files. The files are my.ini,my-huge.ini,my-innodb-heavy-4G.ini,my-large.ini,my-medium.ini,my-small.ini and my-template.ini. So which one is being used as the configuration files. I assume it is the my.ini one right ? So why is there so many other ini files? My another question is that in my.ini I dont find the option for the bin-log settings but ? Because I want to the option of binary log to be enable to allow me to trace back if there is any mistake ?

Changes To My.cnf File For Review
Okay, I'm hoping someone can review the changes I propose to make to the my.cnf file for our installation. I'm new to the administration side of things and want to make certain my syntax, etc. are okay. We're still in the development stage of things, so that's why the changes are pretty basic and (for now) I want query logging on.

I'd also appreciate any input on 'must have' options in the configuration. We will be a web-based application with periodic bulk updates, user access controlled via the middleware.

Here is the my.cnf content:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysql/log.err
# query logging added april 17 2007, turn off for production implementation
log=/var/log/mysql/querylog
log-bin=/var/log/mysql/logbin

#Disallow authentication for accounts that have old (pre-4.1) passwords.
secure-auth

# INNODB specific settings
# The default storage engine that will be used when create new tables

default-storage-engine=INNODB

# If set to 1, InnoDB will flush (fsync) the transaction logs to the
# disk at each commit, which offers full ACID behavior. If you are
# willing to compromise this safety, and you are running small
# transactions, you may set this to 0 or 2 to reduce disk I/O to the
# logs. Value 0 means that the log is only written to the log file and
# the log file flushed to disk approximately once per second. Value 2
# means the log is written to the log file at each commit, but the log
# file is only flushed to disk approximately once per second.

innodb_flush_log_at_trx_commit=1

[mysql.server]
user=mysql
basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

Where Does The Backup File Go?
I cannot find the msqldump backup file after issuing the command. When I do a google desktop search it does not show up. I've looked in the bin folder, the data folder, the mysql 5.0 server folder -- alas it is not their.

Here is the command I issue

>mysqldump -u root -p naasf > nasskbak.sql

I then get the following

>password:

I enter the password, about 3 seconds pass, and then the dos prompt returns.

I assume the dump file is being made, but I can't seem to find it.

BTW, I did check the PATH variable and it is set the mysql server bin.

File Database
I am trying to design a db that users can download files from. In simple terms a user is going to search for a picture and then according to the name of the pic the link to download is going to pop-up.I am working with PHP and mysql. Does anybody have any idea how I can implement this?

Run Query From A File
I tried:

mysql> source 'file_name';

and

mysql> . 'file_name'

right now I'm running version 4.0.something on WinXP and I repeatedly get the following error:

Failed to open file 'file_name', error: 2

Any ideas?

MYI File Difference
I tarred up the data directory from mirror1 data base - slave. Copied the
tarball to mirror2 with the hopes of rebuilding mirror2 - another slave.
Backed up the data directory from mirror2 into old and untarred mirror1

Then I did a diff -r against another mirror and the diff came back with

Binary files old/blahblahblah.MYI and data/blahblahblah.MYI differ,

For all the .MYI files.

Any insight as to why these indexes are different?

------_=_NextPart_001_01C34BE8.3ABE1EE0--

Jpg File Insertion
I want to store jpg files to BLOB field of a table. That
table has other fields which are integer and char types. So i
tried inserting image using
LOAD DATA INTO ...... statement . It got stored , but when i
retrieve it back , i'm not able to see the image file.I hope it
didn't get stored in proper format. How do i acheieve this ??
__________________________________________________ _
Download the hottest & happening ringtones here!
OR SMS: Top tone to 7333

What Is A Config File ?

The following message shows me an error at my Config Wizzard "The template configuration file cannot be found message "C:Archivos de ProgramaMySQL Server 5.0MySQLinmy-template.cnf" Any thoughts?

The following message shows me an error at my Config Wizzard "The template configuration file cannot be found message "C:Archivos de ProgramaMySQL Server 5.0MySQLinmy-template.cnf"

Any thoughts?