[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 the
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]
>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: http://www.ph
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 (actuall
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 t
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 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 n
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
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 f
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 er
"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
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 M
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 I
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
puposel
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 t
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
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 (
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) < name_of_dump_fil
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 anoth
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 v
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
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://localhost/ph
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 bundl
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. bo
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 p
27 matches
Mail list logo
