PHP MYADMIN help? :(

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

PHP MYADMIN help? :(

Post 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!
User avatar
protokol
Forum Contributor
Posts: 353
Joined: Fri Jun 21, 2002 7:00 pm
Location: Cleveland, OH
Contact:

Post 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
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

Post by JPlush76 »

in the phpmyadmin config file?

Code: Select all

$cfgServersї1]ї'host']          = 'localhost'; // MySQL hostname

there u mean?
User avatar
protokol
Forum Contributor
Posts: 353
Joined: Fri Jun 21, 2002 7:00 pm
Location: Cleveland, OH
Contact:

Post by protokol »

no, the setting above it .. the one where you specify the full path to the phpmyadmin directory
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

Post 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
User avatar
protokol
Forum Contributor
Posts: 353
Joined: Fri Jun 21, 2002 7:00 pm
Location: Cleveland, OH
Contact:

Post 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
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

Post 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? :(
User avatar
protokol
Forum Contributor
Posts: 353
Joined: Fri Jun 21, 2002 7:00 pm
Location: Cleveland, OH
Contact:

Post by protokol »

that means you can only access phpmyadmin from the local address then
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

Post 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 :(
User avatar
protokol
Forum Contributor
Posts: 353
Joined: Fri Jun 21, 2002 7:00 pm
Location: Cleveland, OH
Contact:

Post by protokol »

oh duh, i totally read the original question wrong
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
JPlush76
Forum Regular
Posts: 819
Joined: Thu Aug 01, 2002 5:42 pm
Location: Los Angeles, CA
Contact:

Post 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?
User avatar
twigletmac
Her Royal Site Adminness
Posts: 5371
Joined: Tue Apr 23, 2002 2:21 am
Location: Essex, UK

Post 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
Post Reply