Closed Thread Icon

Topic awaiting preservation: phpmyadmin need assistance (Page 1 of 1) Pages that link to <a href="https://ozoneasylum.com/backlink?for=26597" title="Pages that link to Topic awaiting preservation: phpmyadmin need assistance (Page 1 of 1)" rel="nofollow" >Topic awaiting preservation: phpmyadmin need assistance <span class="small">(Page 1 of 1)</span>\

 
Seymour
Bipolar (III) Inmate

From: K-town, FL, USA
Insane since: Jun 2002

posted posted 09-07-2005 21:58

I have worked with a little php before but at college I have been assigned to work with it through phpmyadmin and I was wonding if anyone here has dealt with it before. In an a littel confused by how everything is set up. My job is pretty simple. All that I need to do is add an extra field to an existing structure but I was unable to navigate the program that well. I also need to know how to copy the php files in myadmin so that I can make a back up incase I f*it up. Any help would be greatly appreciated, thank you all

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted posted 09-08-2005 01:07

Basically it's fairly straight forward.

On the left frame you should have the navigation of the database and the various tables. Clicking on a table will show you the schema and give you the option of adding 1 to however many fields at the end of the table. You can also browse fields by clicking on the tabs across the top.

Clicking on the Export tab on the top should give you the ability to dump both Structure and or data to a text file for backup.



.:[ Never resist a perfect moment ]:.

Pugzly
Paranoid (IV) Inmate

From: 127.0.0.1
Insane since: Apr 2000

posted posted 09-08-2005 03:34

Just about everyone who deals with PHP and MySQL has experience with phpmyadmin. You can't beat it for an admin GUI for MySQL.

You can run queries within the interface, import, export, create, etc.

Anything you might need to do.

Seymour
Bipolar (III) Inmate

From: K-town, FL, USA
Insane since: Jun 2002

posted posted 09-08-2005 06:46

well I am very glad that someone in the asylum has some background with it... I might be coming to you with a little few more questions this semester then. Thanks a lot.. you guys really know how to save an ass.

Tyberius Prime
Paranoid (IV) Mad Scientist with Finglongers

From: Germany
Insane since: Sep 2001

posted posted 09-08-2005 09:20

Indeed, it is quite powerful.
Now, if only they stopped changing the icons with every release...

Pugzly
Paranoid (IV) Inmate

From: 127.0.0.1
Insane since: Apr 2000

posted posted 09-09-2005 02:08

I'd like to see an option to import from a file stored in the server file system (in addition to the local file option).

Skaarjj
Maniac (V) Mad Scientist

From: :morF
Insane since: May 2000

posted posted 09-11-2005 08:11

I wonder, pugzly, if perhaps you could provide it with a URL instead of a local file path in the import section... perhaps that would work.


Justice 4 Pat Richard

bitdamaged
Maniac (V) Mad Scientist

From: 100101010011 <-- right about here
Insane since: Mar 2000

posted posted 09-12-2005 18:13

you can do this from the command line with mysqlimport



.:[ Never resist a perfect moment ]:.

« BackwardsOnwards »

Show Forum Drop Down Menu