hi,

actually, a friend of mine has a problem where when she uploaded her database into the server, the database title(name) and the fields(column) name are not there but the data of each field is there. dont know either it is not uploaded as well or it erase or vanish on its own or is it suppose to be like that..this is our first time uploading anything to servers or such..please advise...

Thank you in advance..

Re: database uploaded to server with missing field, what to do? 80 80

What database app was uploaded. If is MSSQL or MySQL, the plhosting provider should be providing a management console so that you can manage the database.

Re: database uploaded to server with missing field, what to do? 80 80

How can the fields not be there but the data is still present? That makes zero sense to me.

If the fields in a table aren't setup correctly you need to run an Alter Table command (or whatever for yoru particuliar DB) and add/edit the fields. Then run your data import again.

Re: database uploaded to server with missing field, what to do? 80 80

actually the field name is not there..not in the database..the eg:

Fullname           Address                   Position   

1 Hanna Tan 2/3 precient 10 1209839 Manager File/filename.pdf
2 Michy yoo chun 2/1 precient 11 8839489 Marketing File/filename.pdf

as you can see the above table..

there are some missing field name such as (password and file_name)

Fullname Address + Position +

all the data in the field si still there...

1 Hanna Tan 2/3 precient 10 1209839 Manager File/filename.pdf
2 Michy yoo chun 2/1 precient 11 8839489 Marketing File/filename.pdf

Re: database uploaded to server with missing field, what to do? 80 80

So you need to ALTER TABLE (or whatever) and create the new fields for password and filename. Then re-import the data again.

Re: database uploaded to server with missing field, what to do? 80 80

oo..alright..thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.19 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.