Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    24
    Plugin Contributions
    0

    Default Faster way to remove tables in phpMyAdmin?

    In my attempt to update the database, I find myself with tables from the old and new databases. These tables differ in their prefix.

    Other than creating a brand new database, or deleting one table are at a time, is there a "select all" for deleting the 100 or so tables with the wrong prefix?

    I can only click on one table at a time and use the "drop" button on the right.

    thanks
    tc

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Faster way to remove tables in phpMyAdmin?

    Tick all the desired boxes and use the drop option at the bottom of the list.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. MySQL to display changed tables / rows - phpmyadmin
    By DogTags in forum General Questions
    Replies: 2
    Last Post: 29 Sep 2011, 05:42 PM
  2. Is there a faster way to load 100.000+ products ?
    By artistic in forum General Questions
    Replies: 6
    Last Post: 7 Aug 2009, 05:09 PM
  3. is there a easier and faster way to add size?
    By doremon313 in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 9 Mar 2009, 06:48 PM
  4. phpMyAdmin database tables export/import for categories ect. help
    By oxicottin in forum Installing on a Windows Server
    Replies: 0
    Last Post: 2 Sep 2007, 10:46 PM
  5. Editing tables directly with phpMyAdmin
    By shocker in forum Setting Up Categories, Products, Attributes
    Replies: 1
    Last Post: 31 Aug 2007, 05:18 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR