alex wrote:
hi everyone
i have delete a few entries in my database as they were entered for testing
purposes and are no longer need (actually 102 entries)... and even thought
that db is empty i noticed that when the next entry went in the id number
went to 103
not 0 so i was wondering is it
At 1:42 PM -0600 4/16/06, Chuck Anderson wrote:
alex wrote:
hi everyone
i have delete a few entries in my database as they were entered for
testing purposes and are no longer need (actually 102 entries)...
and even thought that db is empty i noticed that when the next
entry went in the id
tedd wrote:
At 1:42 PM -0600 4/16/06, Chuck Anderson wrote:
alex wrote:
hi everyone
i have delete a few entries in my database as they were entered for
testing purposes and are no longer need (actually 102 entries)...
and even thought that db is empty i noticed that when the next
At 3:01 PM -0600 4/16/06, Chuck Anderson wrote:
tedd wrote:
At 1:42 PM -0600 4/16/06, Chuck Anderson wrote:
alex wrote:
hi everyone
i have delete a few entries in my database as they were entered
for testing purposes and are no longer need (actually 102
entries)... and even thought
tedd wrote:
At 3:01 PM -0600 4/16/06, Chuck Anderson wrote:
tedd wrote:
At 1:42 PM -0600 4/16/06, Chuck Anderson wrote:
alex wrote:
hi everyone
i have delete a few entries in my database as they were entered
for testing purposes and are no longer need
[snip]
2. Reset the auto_increment in Operations to 101
[/snip]
This isn't another of those 'reseting the auto-increment' holy war
questions where you use the AI number as an identifier for the record,
is it?
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit:
Jay Blanchard wrote:
[snip]
2. Reset the auto_increment in Operations to 101
[/snip]
This isn't another of those 'reseting the auto-increment' holy war
questions where you use the AI number as an identifier for the record,
is it?
Nope. And I have no intention of taking it there.
[snip]
I just get obsessive and thorough when testing and then I don't like
stale data in my database - so I like to reset everything. It would be
better to backup before testing and then restore. Resetting the AI just
makes it the same as if you had.
[/snip]
I agree, that is why I truncate
Chris W wrote:
I just tried to use the output of the export function on phpmyadmin and
got a million errors. After looking at the file I found that certain
columns that are strings were not quoted at all. I can't find any
reason why some are and some are not quoted. Anyone have any idea
Sorry, here is the English version:
I have just set the Apache Default Char Set to UTF-8. Same thing in the
phpmyadmin config file.
I chose de-utf-8 in the phpmyadmin GUI.
When I try to look at a particular database the following error comes up.
Can not load iconv or recode extension needed
Simplest is to go into your config file and turn that on.
Freedomware wrote:
I've been using both phpMyAdmin and EMS MySQL Manager to work with MySQL
tables and PHP. Things are generally going OK, but I'm still ironing out
a few kinks. I suspect some of my problems might be related to an
Joffrey L Leevy [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Hi all:
I was trying to use phpmyadmin for the first time and messed up when
trying
to give the [EMAIL PROTECTED] a password. I did that because phpmyadmin told
me something about lax security using root with no
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
Hello All,
I am using phpMyAdmin to administer my MySQl DB. I am running Mac OS
Jaguar.
when I try to start up phpMyAdmin I get an error:
Welcome to phpMyAdmin 2.4.0
Error
MySQL said:
Can't connect to local MySQL server
Pushpinder Singh Garcha wrote:
Hello ,
I am using PhpMyAdmin to control my MySQL Database. Untill now I had
been using the Local Apache webserver to test my scripts, so I had
installed PhpMyAdmin in the 'Sites' Folder of my Mac. Now I need to beta
test the Application on the Live Server. Do
What you can and can't do with phpMyAdmin may depend on your host.
phpMyAdmin itself does have the ability to create databases. However, that
ability is determined by the access rights of the user you access the MySQL
server with. If your host controls the creation of that user, they may
So sprach Steve Jackson am 2002-08-20 um 22:11:58 +0300 :
seperate ones for seperate functions.. Ideas or advice? is the way I am
suggesting better or worse than the way my hosting company expects me to
work?
What does your hosting company suggest?
Any how, for system stuff like creating
i am using IE
Julio Nobrega [EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]...
Electroteque em Friday 26 July 2002 11:19 foi agraciado com uma resposta
por:
hi guys i am having major caching issues in phpMyAdmin when i moved to
apache 2.0.39 has anyone else expeirence this ? its
dump all the data to csv and read it in the other end!
Phil Schwarzmann [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
The lazy and worthless a-holes at www.infinitehost.com (my host server)
are forcing me to move all my MySQL data from one server to another
Can't he just dump the db to a file and then load it on the new server? I
do that all of the time between my laptop and work.
Dump the db into a sql file (choosing data and structure for the dump)
Create a new db on the server
then run: mysql -u xxx -p xxx -D (database name)
Just dump the data and structure to an SQL file, choose save as file, then
run all the code in the file on the next server.
Taylor York
Phil Schwarzmann [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
The lazy and worthless a-holes at www.infinitehost.com (my
if your database is more than a couple mb you may not
be able to do this - shared hosts limit your max
memory per script and max upload size.
Use select into outfile like this:
SELECT a,b,a+b INTO OUTFILE /tmp/result.text
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ''
LINES TERMINATED BY \n
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
I am using the latest phpMyAdmin and MySQL 2.23.37. I have installed and
compiled it on a Sun Cobalt RAQ4r. I need to have it set up so that
customers with different websites cannot see or work on other cutomers DB's,
but each
PhpMyadmin now have somekind of authentication method. From the docs:
What's the preferred way of making phpMyAdmin secure against evil access?
This depends on your system.
If you're running a server which cannot be accessed by other people, it's
sufficient to use the directory protection
you can use the built in auth system.
see phpmyadmin manual
Mantas Kriauciunas [EMAIL PROTECTED] schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hey PHP General List,
Can anybody point me to tutorial or real good explanation site how
to keep
http://httpd.apache.org/docs/configuring.html#htaccess
http://apache-server.com/tutorials/ATusing-htaccess.html
Use this to enable username and password access to phpMyAdmin.
Later,
Bob
Mantas Kriauciunas [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
Hey PHP
In article [EMAIL PROTECTED],
[EMAIL PROTECTED] says...
OK, here its goes. I learned of this neat little app phpMyadmin add=
ed a
password to root and now I get no access.
checked the my.ini and php.ini for possible problems there. they are s=
et
with passwords to the root. both .ini's
You might want to try phpbuilder, they have some great articles. phpMyAdmin
is housed on sourceforge.net. You can check them out there...
Jtjohnston [EMAIL PROTECTED] wrote in message
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
I know this is a bit off the wall for most, but for what
27 matches
Mail list logo