PHP MYADMIN help? :(
Moderator: General Moderators
-
JPlush76
- Forum Regular
- Posts: 819
- Joined: Thu Aug 01, 2002 5:42 pm
- Location: Los Angeles, CA
- Contact:
PHP MYADMIN help? :(
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!
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!
- protokol
- Forum Contributor
- Posts: 353
- Joined: Fri Jun 21, 2002 7:00 pm
- Location: Cleveland, OH
- Contact:
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
just change that address to your public server ip or domain, and you're set
-
JPlush76
- Forum Regular
- Posts: 819
- Joined: Thu Aug 01, 2002 5:42 pm
- Location: Los Angeles, CA
- Contact:
in the phpmyadmin config file?
there u mean?
Code: Select all
$cfgServersї1]ї'host'] = 'localhost'; // MySQL hostnamethere u mean?
-
JPlush76
- Forum Regular
- Posts: 819
- Joined: Thu Aug 01, 2002 5:42 pm
- Location: Los Angeles, CA
- Contact:
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
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- protokol
- Forum Contributor
- Posts: 353
- Joined: Fri Jun 21, 2002 7:00 pm
- Location: Cleveland, OH
- Contact:
Change that line .. it should be something likeJPlush76 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/';
http://www.something.com/PHP_Admin
-
JPlush76
- Forum Regular
- Posts: 819
- Joined: Thu Aug 01, 2002 5:42 pm
- Location: Los Angeles, CA
- Contact:
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?
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?
-
JPlush76
- Forum Regular
- Posts: 819
- Joined: Thu Aug 01, 2002 5:42 pm
- Location: Los Angeles, CA
- Contact:
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
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
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
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
Mac
- twigletmac
- Her Royal Site Adminness
- Posts: 5371
- Joined: Tue Apr 23, 2002 2:21 am
- Location: Essex, UK
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
Mac