Creating a new database in phpmyadmin

  • Resolved johnhardy

    (@johnhardy)


    1 year ago

    Hello, I am a Newby at WordPress and am installing a new site.

    Using phpmyadmin to create a new database, I select Create new table and give this an appropriate name.

    The new item appears in the list of databases but when I select the database name no tables have been created. I thought that around 20 tables are usually created.

    Can anyone please advise me further.

    Many thanks

    John H

    The page I need help with: [log in to see the link]

Viewing 9 replies - 1 through 9 (of 9 total)
  • Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    Are you trying to create a database for WordPress? If so, when you install WP, it will create the necessary tables. You do not need to (and should not) create tables yourself.

    Thread Starter johnhardy

    (@johnhardy)

    I found this code

    Error

    SQL query: Copy

    CREATE TABLE bookladdermatch_form ( 
id INT(20) NOT NULL, 
date_fld DATE NOT NULL,
time_fld TIME(20) NOT NULL,
challenger_fld VARCHAR(20) NOT NULL,
opponent_fld VARCHAR(20) NOT NULL
);

    MySQL said:?#1426 - Too big precision 20 specified for 'time_fld'. Maximum is 6

    I believe from what I read this can be changed, can anyone advise how this can be carried out please?

    Thanks

    John H

    threadi

    (@threadi)

    The code described is not part of WordPress. What do you think it has to do with WordPress?

    If you want to install WordPress, proceed as described by @sterndata. There are also instructions here: https://developer.www.ads-software.com/advanced-administration/before-install/howto-install/

    Thread Starter johnhardy

    (@johnhardy)

    I have already installed WordPress and was able to create several test databases including tables with no problems. Suddenly that has changed so that on a database creation no tables are created.

    After searching for a solution I discovered the article and mistakenly thought the code I found may assist.

    Any other suggestions please? Thank you

    John H

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    You need only create a database; do not create the tables.

    Thread Starter johnhardy

    (@johnhardy)

    Hello Steven

    Just checking!…..

    As above no tables are created automatically and that’s OK? So for a listing site where/how does the information detail get stored please?

    John H

    Thanks Steven,

    Moderator Steven Stern (sterndata)

    (@sterndata)

    Volunteer Forum Moderator

    WHen you install WP and get to the screen where it asks for database credentials — that’s when and where it will create the tables.

    Thread Starter johnhardy

    (@johnhardy)

    Very Many thanks.

    John H

    Thread Starter johnhardy

    (@johnhardy)

    Marking Resolved

Viewing 9 replies - 1 through 9 (of 9 total)
  • The topic ‘Creating a new database in phpmyadmin’ is closed to new replies.