RE: [PHP] Re: phpMyAdmin--resetting auto increments to 0
[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 tables after testing, if I am testing on the production box. [snip] And my real question is about PhpMyAdmin and why it no longer seems to let you reset the AI using the Operations page. At least it doesn't on my machine - Windows XP - Apache/2.0.55 - PhpMyAdmin 2.6.4-pl3. [/snip] Hmmmdoesn't phpMyAdmin have a list or bug report? I know that a bunch of us use it here...but this may be specific enough for the more specific lists. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0
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. 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. And my real question is about PhpMyAdmin and why it no longer seems to let you reset the AI using the Operations page. At least it doesn't on my machine - Windows XP - Apache/2.0.55 - PhpMyAdmin 2.6.4-pl3. -- * Chuck Anderson • Boulder, CO http://www.CycleTourist.com Integrity is obvious. The lack of it is common. * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] Re: phpMyAdmin--resetting auto increments to 0
[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.php.net/unsub.php
Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0
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 (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 possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex On a related note (he did say PhpMyAdmin) ... ALTER TABLE 'tablename' auto_increment=n works, but I can't get PhpMyAdmin to reset the auto_increment through the Operations menu page. If I go to the Operations tab for a table and set the auto_increment value to something less that it currently is, PhpMyAdmin will not honor my request and re-specifies the current auto_increment value in the ALTER TABLE command (even though my requested value is valid). Is this because of a config setting? I could have sworn earlier versions would obey my request. Chuck: This always works for me in PhpMyAdmin (I mistyped it before). 1. Delete the first record. 2. Reset the auto_increment in Operations to whatever you want. 3. Insert a record. 4. Delete that record. After that, the next record will start at the new auto_increment value. Don't ask why, that's just the way it works. tedd That would work, except that I want to change the auto_increment without deleting the first record. During testing I may add many entries to the end of an existing database table. When I am done testing I want to delete those "extraneous" entries (leaving the earlier entries intact). Call me obsessive/compulsive or whatever, but I like to knock the auto_increment value back down to the next valid value (what was the first "test" value). PhpMyAdmin refuses to use the valid auto_increment value I specify in Operations and I have to edit the query to set it right. Chuck: Okay, then delete whatever record you want and reset the auto_increment value to that -- for example: Let's say you have records 0 - 100 that you want to keep. Then you added some test records that went from 101 to 150 and now you want to delete those records and start again at 101, right? Simple, just: 1. Delete records 101-150. 2. Reset the auto_increment in Operations to 101 3. Insert a false record. 4. Delete that false record. Now, your dB will be set to start at 101. What's even more amazing (at least I've found), is that if you had 0-100 records you wanted to keep and 101-150 you wanted to delete, but also had 151 to 200 you also wanted to keep, you could do what I said above and the auto_increment would fill up 101-150 and then jump to 201. It's neat the way it works. At least that's my memory. Try it. tedd I appreciate your help here . but 2. Reset the auto_increment in Operations to 101 That's the part that PhpMyAdmin refuses to do. It will not alter it to less than 151 (per your example). PhpMyAdmin 2.6.4-pl3 It's not much work to then edit the PhpMyAdmin query to my liking, but I don't think I used to have to do that. I like your second part about filling in the between stuff. If I'm at that point, though, I delete the auto_increment field (sorting the table by date) and then add it back in. That fills all the gaps, too. What I want to know is why PhpMyAdmin will not do your step 2. I swear that earlier versions would let me do that. -- * Chuck Anderson • Boulder, CO http://www.CycleTourist.com Integrity is obvious. The lack of it is common. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0
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 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 possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex On a related note (he did say PhpMyAdmin) ... ALTER TABLE 'tablename' auto_increment=n works, but I can't get PhpMyAdmin to reset the auto_increment through the Operations menu page. If I go to the Operations tab for a table and set the auto_increment value to something less that it currently is, PhpMyAdmin will not honor my request and re-specifies the current auto_increment value in the ALTER TABLE command (even though my requested value is valid). Is this because of a config setting? I could have sworn earlier versions would obey my request. Chuck: This always works for me in PhpMyAdmin (I mistyped it before). 1. Delete the first record. 2. Reset the auto_increment in Operations to whatever you want. 3. Insert a record. 4. Delete that record. After that, the next record will start at the new auto_increment value. Don't ask why, that's just the way it works. tedd That would work, except that I want to change the auto_increment without deleting the first record. During testing I may add many entries to the end of an existing database table. When I am done testing I want to delete those "extraneous" entries (leaving the earlier entries intact). Call me obsessive/compulsive or whatever, but I like to knock the auto_increment value back down to the next valid value (what was the first "test" value). PhpMyAdmin refuses to use the valid auto_increment value I specify in Operations and I have to edit the query to set it right. Chuck: Okay, then delete whatever record you want and reset the auto_increment value to that -- for example: Let's say you have records 0 - 100 that you want to keep. Then you added some test records that went from 101 to 150 and now you want to delete those records and start again at 101, right? Simple, just: 1. Delete records 101-150. 2. Reset the auto_increment in Operations to 101 3. Insert a false record. 4. Delete that false record. Now, your dB will be set to start at 101. What's even more amazing (at least I've found), is that if you had 0-100 records you wanted to keep and 101-150 you wanted to delete, but also had 151 to 200 you also wanted to keep, you could do what I said above and the auto_increment would fill up 101-150 and then jump to 201. It's neat the way it works. At least that's my memory. Try it. tedd -- http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: phpMyAdmin--resetting auto increments to 0
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 entry went in the id number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex On a related note (he did say PhpMyAdmin) ... ALTER TABLE 'tablename' auto_increment=n works, but I can't get PhpMyAdmin to reset the auto_increment through the Operations menu page. If I go to the Operations tab for a table and set the auto_increment value to something less that it currently is, PhpMyAdmin will not honor my request and re-specifies the current auto_increment value in the ALTER TABLE command (even though my requested value is valid). Is this because of a config setting? I could have sworn earlier versions would obey my request. Chuck: This always works for me in PhpMyAdmin (I mistyped it before). 1. Delete the first record. 2. Reset the auto_increment in Operations to whatever you want. 3. Insert a record. 4. Delete that record. After that, the next record will start at the new auto_increment value. Don't ask why, that's just the way it works. tedd That would work, except that I want to change the auto_increment without deleting the first record. During testing I may add many entries to the end of an existing database table. When I am done testing I want to delete those "extraneous" entries (leaving the earlier entries intact). Call me obsessive/compulsive or whatever, but I like to knock the auto_increment value back down to the next valid value (what was the first "test" value). PhpMyAdmin refuses to use the valid auto_increment value I specify in Operations and I have to edit the query to set it right. -- * Chuck Anderson • Boulder, CO http://www.CycleTourist.com Integrity is obvious. The lack of it is common. * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin--resetting auto increments to 0
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 number went to 103 not 0 so i was wondering is it possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex On a related note (he did say PhpMyAdmin) ... ALTER TABLE 'tablename' auto_increment=n works, but I can't get PhpMyAdmin to reset the auto_increment through the Operations menu page. If I go to the Operations tab for a table and set the auto_increment value to something less that it currently is, PhpMyAdmin will not honor my request and re-specifies the current auto_increment value in the ALTER TABLE command (even though my requested value is valid). Is this because of a config setting? I could have sworn earlier versions would obey my request. Chuck: This always works for me in PhpMyAdmin (I mistyped it before). 1. Delete the first record. 2. Reset the auto_increment in Operations to whatever you want. 3. Insert a record. 4. Delete that record. After that, the next record will start at the new auto_increment value. Don't ask why, that's just the way it works. tedd -- http://sperling.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin--resetting auto increments to 0
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 possible to somehow reset the value to zero... it is of int type and auto_increment i have a few db's which id like to reset to zero i have tried placing a zero enrty after deleting the lot but it only jumps to its next increment. does anyone know what i mean...? any help will be grateful regards alex On a related note (he did say PhpMyAdmin) ... ALTER TABLE 'tablename' auto_increment=n works, but I can't get PhpMyAdmin to reset the auto_increment through the Operations menu page. If I go to the Operations tab for a table and set the auto_increment value to something less that it currently is, PhpMyAdmin will not honor my request and re-specifies the current auto_increment value in the ALTER TABLE command (even though my requested value is valid). Is this because of a config setting? I could have sworn earlier versions would obey my request. -- * Chuck Anderson • Boulder, CO http://www.CycleTourist.com Integrity is obvious. The lack of it is common. * -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpmyadmin problems with quoting exported text
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 why > this is happening? > Been there, done that, upgraded the PMA :-) Cheers -- David Robley I lost a button hole today. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpmyadmin and UTF
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 for charset conversion, configure php to allow using these extensions or disable charset conversion in phpMyAdmin. " How can that be fixed ? Thank you. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin Problems
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 error > message I get when I click on a Database in phpMyAdmin: > > "Error: The additional Features for working with linked Tables have been > deactivated. To find out why click here." > > When I click the link, I get a page that lists six different problems, > each linked to a pretty complex solution in the phpMyAdmin Manual. Does > anyone here know if there's an easier solution? Would fixing one or two > key problems automatically fix the others? Can you download files that > have already been "fixed," add your username and password and paste them > into the proper folders? > > I put a couple screenshots that illustrate what I described online at > http://geowebworks.geobop.org/test/phpmyadmin/index.php > > Thanks. -- John Taylor-Johnston - "If it's not Open Source, it's Murphy's Law or broken." ' ' ' Collège de Sherbrooke ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/ - Université de Sherbrooke http://compcanlit.ca/ 819-569-2064 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpmyadmin foulup
"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 password. Anyhow > something went wrong. > > > Now I can't do anything with phpadmin or mysql client.The message is - > "Error 1045: Access Denied for User: (Using Password:No). Grateful for > anyone's help. If you know what the password is, this is how you use it at the command line: mysql -u root -p Then it will prompt you for the password. If you don't know the password... H... -- Rob > > > Thanks -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PhpMyAdmin / MySQL
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 through socket '/tmp/mysql.sock' (2) > > > So I try to start up the MySQL Server manually by typing the following > on my command prompt: > and here are the results: > > [psg:/usr/local/mysql] psgarcha% sudo ./bin/mysqld_safe & > [1] 558 > [psg:/usr/local/mysql] psgarcha% Starting mysqld daemon with databases > from /usr/local/mysql/data > 030616 10:16:32 mysqld ended > > > Please help. Thanks in advance. Does the mysql log tell you anything useful? -- Quod subigo farinam $email =~ s/oz$/au/o; -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PhpMyADmin Help
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 need to upload PhpMyAdmin on to the remote site? Or can I let it remain sitting on the local server. Also, I was wondering , what value should I assign to the $cfg['PmaAbsoluteUri'] variable in the config.inc.php file. Many Thanks, Pushpinder Pushpinder Singh Garcha _ Web Architect $cfg['PmaAbsoluteUri'] --- http://localhost/admin/ or /admin/ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin is this possible
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 puposely restrict your access rights to dissallow the creation of additional databases. I had this very problem with an old host of mine. I was given one database and that was it. I could not create any more. Now, my current host (www.webprosinc.net) works a bit different. It is using Plesk, which takes over the responsibility of creating databases and users. The users that it creates do not have the ability to create additional databases, though just about all other access rights are granted (at the database level). This gives the Plesk software absolute control over the MySQL server while still allowing me to create new databases. So, I would make sure your host allows you to create additional databases before you try to get phpMyAdmin to do it. If this is an important feature and your current host does not allow it, there are several other hosts (mine included) that do give that access (usually with some restrictions, of course). --- Seairth Jacobs [EMAIL PROTECTED] "Steve Jackson" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I am new to MySQL and PHP. > Having looked at PHPMyAdmin the GUI I was wondering if it's possible to > create a new database within the system? > If so what are the commands? I ask because I only have one database on my > server and don't want to populate it with different tables, I'd rather have > 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? > Thanks in advance. > Steve. > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin is this possible
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 databases and especially setting ACL, I much more prefer to use Webmin. Alexander Skwar -- How to quote: http://learn.to/quote (german) http://quote.6x.to (english) Homepage: http://www.iso-top.biz |Jabber: [EMAIL PROTECTED] iso-top.biz - Die günstige Art an Linux Distributionen zu kommen Uptime: 2 days 2 hours 27 minutes -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin and apqache 2.0.39 cache problems
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 sending me round the > > bend , i cant view my mysql tables when i create them , i have to removed > > temp internet files and hit refresh to get them to view > > Yes! But only with the Opera navigator, and while using localhost. With > Internet Explorer, doesn't happen. > > -- > -- > http://gnet.inerciasensorial.com.br -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: phpmyadmin - moving data from one database to another
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" FROM test_table; It will write the data to a delimited file - then upload this file to new server and use LOAD DATA INFILE much the same way SELECT INTO OUTFILE http://www.mysql.com/doc/S/E/SELECT.html LOAD DATA INFILE http://www.mysql.com/doc/L/O/LOAD_DATA.html olinux --- Taylor York <[EMAIL PROTECTED]> wrote: > 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 host server) > > are forcing me to move all my MySQL data from one > server to another > > because they are too dumb to fix it. > > > > I need to use phpmyadmin to move the data but i'm > not %100 sure how to > > do it. There are some "view dump" commands. It > looks like I can > > somehow download all the data and structure to my > local computer, then > > upload it to the new server. > > > > Anyone have any info on this? > > > > THanks! > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpmyadmin - moving data from one database to another
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 host server) > are forcing me to move all my MySQL data from one server to another > because they are too dumb to fix it. > > I need to use phpmyadmin to move the data but i'm not %100 sure how to > do it. There are some "view dump" commands. It looks like I can > somehow download all the data and structure to my local computer, then > upload it to the new server. > > Anyone have any info on this? > > THanks! > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Re: phpmyadmin - moving data from one database 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) < name_of_dump_file On Tue, 18 Jun 2002, BB wrote: > 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 > > because they are too dumb to fix it. > > > > I need to use phpmyadmin to move the data but i'm not %100 sure how to > > do it. There are some "view dump" commands. It looks like I can > > somehow download all the data and structure to my local computer, then > > upload it to the new server. > > > > Anyone have any info on this? > > > > THanks! > > > > > > -- - Now Playing: Simple Minds - All The Things She Said Server Uptime: 189 days www.scottah.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpmyadmin - moving data from one database to another
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 > because they are too dumb to fix it. > > I need to use phpmyadmin to move the data but i'm not %100 sure how to > do it. There are some "view dump" commands. It looks like I can > somehow download all the data and structure to my local computer, then > upload it to the new server. > > Anyone have any info on this? > > THanks! > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: PhpMyAdmin
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 virtual site has its one phpMyAdmin > > So each user needs to have his own phpMyAdmin to work in with his own DB's. > > Can anyone please explain how this is done. If this is the wrong list I > apologize but I did not know which one to post to. If it si the wrong list > does any one know of a phpMyAdmin list. > > Any help would be really great. I'll even throw in a free web hosting > account. > > Bernie-- I think you need to set the $cfgServers[1]['only_db'] = ''; // If set to a db-name, only this db is accessible line in their respective config.inc.php and of course have the appropriate grants set on the various dbs. -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin protection
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 General List, > > Can anybody point me to tutorial or real good explanation site how > to keep Http://localhost/phpmyadmin off for other users. I am using > it to help me with MySQL database but other peaople can access > it. I know there is something with .httacces but i dont know > anything about that .httacces. SO please if anybody can point me to > some explanation how to secure phpmyadmin or just explain bu them > selves. > > Thank You. > > :--: > Have A Nice Day! > Mantas Kriauciunas A.k.A mNTKz > > Contacts: > [EMAIL PROTECTED] > Http://mntkz-hata.visiems.lt > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin 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://localhost/phpmyadmin off for other users. I am using > it to help me with MySQL database but other peaople can access > it. I know there is something with .httacces but i dont know > anything about that .httacces. SO please if anybody can point me to > some explanation how to secure phpmyadmin or just explain bu them > selves. > > Thank You. > > :--: > Have A Nice Day! > Mantas Kriauciunas A.k.A mNTKz > > Contacts: > [EMAIL PROTECTED] > Http://mntkz-hata.visiems.lt > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin protection
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 bundled with your webserver (with Apache you can use .htaccess files, for example). If other people have telnet access to your server, you should use phpMyAdmin's http authentication feature. Suggestions: Your config.inc.php3 file should be chmod 660. All your phpMyAdmin files should be chown phpmy.apache, where phpmy is a user whose password is only known to you, and apache is the group under which Apache runs. You should use PHP safe mode, to protect from other users that try to include your config.inc.php3 in their scripts. -- Julio Nobrega. Um dia eu chego lá: http://sourceforge.net/projects/toca Ajudei? Salvei? Que tal um presentinho? http://www.submarino.com.br/wishlistclient.asp?wlid=664176742884 "Mantas Kriauciunas" <[EMAIL PROTECTED]> wrote in message [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/phpmyadmin off for other users. I am using > it to help me with MySQL database but other peaople can access > it. I know there is something with .httacces but i dont know > anything about that .httacces. SO please if anybody can point me to > some explanation how to secure phpmyadmin or just explain bu them > selves. > > Thank You. > > :--: > Have A Nice Day! > Mantas Kriauciunas A.k.A mNTKz > > Contacts: > [EMAIL PROTECTED] > Http://mntkz-hata.visiems.lt > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpMyAdmin Change Root pwd ... Now no access
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 > > What am I missing here...should I juyst remove the password from "root"= > ? > You realise that you need to reload mysql so it will read the new grant tables? -- David Robley Temporary Kiwi! Quod subigo farinam -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP] Re: phpmyadmin
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 purpose do you > use phpmyadmin & mysql? > What are your projects? > Does anyone know of any good articles that discuss databasing, PHP, > MySQL and or PHPMyAdmin for academic purposes? > I'm a university researcher and want to collect some data. > > John Taylor-Johnston > -- --- > > ' ' ' Université de Sherbrooke: > ô¿ô http://compcanlit.ca/ >- > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php