Page 1 of 1
PHP MYADMIN help? :(
Posted: Thu Aug 15, 2002 8:42 pm
by JPlush76
I'm using phpmyadmin on my local machine running PWS
I can never back up my database to my local machine from my 3rd party host mysql database either with the load text file or just copy and pasting
it always gives me a "The page cannot be displayed" in the right frame and only enters like 4 or 5 tables in.
its like it has a super small buffer or something because my database isn't that big (18 tables, thousand rows)
anyone know any setting that might be the problem on my config file or windows machine? thanks!
Posted: Thu Aug 15, 2002 8:46 pm
by protokol
you probably made the server address to
http://localhost/path/to/phpmyadmin
just change that address to your public server ip or domain, and you're set
Posted: Thu Aug 15, 2002 8:47 pm
by JPlush76
in the phpmyadmin config file?
Code: Select all
$cfgServersї1]ї'host'] = 'localhost'; // MySQL hostname
there u mean?
Posted: Thu Aug 15, 2002 8:55 pm
by protokol
no, the setting above it .. the one where you specify the full path to the phpmyadmin directory
Posted: Thu Aug 15, 2002 9:09 pm
by JPlush76
nope no love
I changed and it still gives me that page can't be displayed error when I try to run insert queries and such
Code: Select all
**
* Your phpMyAdmin url
*
* Complete the variable below with the full url ie
* http://www.your_web.net/path_to_your_phpMyAdmin_directory/
*/
$cfgPmaAbsoluteUri = 'http://jimbo/PHP_Admin/';
/**
* Server(s) configuration
*/
// The $cfgServers array starts with $cfgServersї1]. Do not use $cfgServersї0].
// You can disable a server config entry by setting host to ''.
$cfgServersї1]ї'host'] = 'localhost'; // MySQL hostname
$cfgServersї1]ї'port'] = ''; // MySQL port - leave blank for default port
$cfgServersї1]ї'socket'] = ''; // Path to the socket - leave blank for default socket
$cfgServersї1]ї'connect_type'] = 'tcp'; // How to connect to MySQL server ('tcp' or 'socket')
$cfgServersї1]ї'stduser'] = ''; // MySQL standard user settings (this user must have read-only
$cfgServersї1]ї'stdpass'] = ''; // access to the "mysql/user" and "mysql/db" tables)
$cfgServersї1]ї'auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfgServersї1]ї'user'] = 'jplus'; // MySQL user
$cfgServersї1]ї'password'] = 'plush'; // MySQL password (only needed with 'config' auth)
$cfgServersї1]ї'only_db'] = ''; // If set to a db-name, only this db is displayed at left frame
// It may also be an array of db-names
$cfgServersї1]ї'verbose'] = ''; // Verbose name for this host - leave blank to show the hostname
$cfgServersї1]ї'bookmarkdb'] = ''; // Bookmark db - leave blank for no bookmark support
$cfgServersї1]ї'bookmarktable'] = ''; // Bookmark table - leave blank for no bookmark support
Posted: Thu Aug 15, 2002 9:14 pm
by protokol
JPlush76 wrote:nope no love
I changed and it still gives me that page can't be displayed error when I try to run insert queries and such
Code: Select all
$cfgPmaAbsoluteUri = 'http://jimbo/PHP_Admin/';
Change that line .. it should be something like
http://www.something.com/PHP_Admin
Posted: Thu Aug 15, 2002 9:18 pm
by JPlush76
but I have it on my local drive
and on pws it says your webserver address is:
http://jimbo
and PHP_Admin is the folder in my root directory
so there isnt' a .com or anything in the address
or am I missing something?

Posted: Thu Aug 15, 2002 9:23 pm
by protokol
that means you can only access phpmyadmin from the local address then
Posted: Thu Aug 15, 2002 9:25 pm
by JPlush76
yea thats how I access it now:
http://jimbo/php_admin/
and it comes up fine and dandy
but when there is a big query I copy and paste in there or if I try to load a text file it gives me that error page

Posted: Thu Aug 15, 2002 9:31 pm
by protokol
oh duh, i totally read the original question wrong
Posted: Fri Aug 16, 2002 2:02 am
by twigletmac
I've had a similar problem with phpMyAdmin although in my case the frame was saying 'page cannot be displayed' but the data was getting entered into the database. When we changed to the latest version of phpMyAdmin the problem seemed to stop then so you might want to get that. If you've got it already the only thing to do would be do run the addition of the data through the command line or split up the text file so that you have a few smaller files instead of one massive one.
Mac
Posted: Fri Aug 16, 2002 11:44 am
by JPlush76
hey Mac, is there a good way to backup/load bigger databases without having to split it up?
how do you do it?
Posted: Sat Aug 17, 2002 10:55 am
by twigletmac
We take a copy of the database from MySQL's data directory and zip it as a backup along with a SQL dump (never hurts to have too many backups). Then we tend to just overwrite the data files directly. However, we do this because it's easier for us not because it's necessarily the best way, although it's worked as a concept thus far. The SQL dump means that if this all goes horribly wrong we've got a fall back position, we also back up the data files before we overwrite them.
Mac